Hello.
I have a process where i want to monitor status of a Record and to save the details about each step with timestamp.
Lets say i have 3 statuses:
Id 1 "it started"
Id 2 "first mail"
Id 3 "second mail"
And I have Record type "History" with columns
Id(primary key), status id, timestamp. I want this Record type to save the data like:
Id1, status id1, 23.12.2022 12:55:00
Id1, status id2, 23.12.2022 12:57:00
Id1, status id3, 23.12.2022 12:59:00
Id2, status id1, 23.12.2022 13:01:00
And so on...
So i can see the precise time when each step occured without overwriting Id1 with last status3 (and only showing this last status on database/Record type).
How can I achieve this?
Currently I'm saving the status id with Script task, but dont know where to tell Process Model that I want to save each step separately. And as i complete the process IT only shows last status on database.
Help will be much appreciated.
Discussion posts and replies are publicly visible
HI, You can create a table called "Audit history" and whenever you do any kind of modification to that particular record, create an entry in audit history table . You would need to use the history records with respective record Id.