Hi All,
I am able to update one entry of a ticket.
In process model, I have update Form view with populated data; i need to store copy as old version i.e. before submit/save using process model as per below screenshot,
How to achieve this?
Finally, i want to get list of all updates done previously for a given ticket number and show in table grid view.
I guess before submit/save i need to add some node.to insert data before save data
Thanks,
Deepak
Discussion posts and replies are publicly visible
As a best practice, maintain a history table in DB, which records the changes.
yes, I want to maintain historic table but how to design process model ? How to design and write ?
The changes to be done on DB side.
Create triggers on the existing table and insert the values into a new history table.I am not sure about the syntaxes, https://mariadb.com/kb/en/trigger-overview/ should be helpful.
From Appian - You can then simply query the history table