Do we have any process model/plugins to capture basic fields for field level audit -
property that changed , old Value, new Value, last updated by, last updated on
Discussion posts and replies are publicly visible
https://docs.appian.com/suite/help/23.2/Appian_Release_Notes.html#capture-and-display-business-events Only in Appian 23.2
There is no direct support for this. You have two options. Use the CDT Diff plugin to find all changes and write them to a separate table. Second, add a trigger to the database which creates a copy of the data before the actual update happens. This way, you can also go back in time.
We are working on 23.1
Got it. Thanks! We are working with records and guess that leaves me with the database triggers option. Will explore it.
You can pretty much replicate what cdtdiff does with a!keys and a a!forEach if you want to do it with Records.
I think that this plugin also works with records. Give it a try.
But this decision depends on what you want to achieve! Is it just about showing changes, or about knowing the state of the data at a certain time in the past.
Thank you for your response.
I believe the plugin cannot be used with record types.
Throws the below error:
'ABC Record can not be used in a customer created plugin function'
However, we are proceeding with the database triggers.
We use this pattern and it works great for record types without relationships. Have you figured out how to support record relationships using this pattern?