How to audit record in Audit table

Hi there,

You can try to add triggers to your audit table.

Regards,

Acacio B

This I can do at database end.

But, I would like to know if there is any mechanism to copy source CDT field values to the destination CDT Audit fields and call Write to Data Store Entity.

Hi,

Trigger is the best option.

But, if you need to execute this in Appian, then create an expression rule.

a!forEach(

items: ri!sourceCDT,

expression type!targetCDT(

param1: fv!item.value1

param2: fv!item.value2

)

Regards,

Farnaz

Thanks

Hi Hari

There are a few things to consider here:

• what is the audit requirement? there are different levels of "audit":
  • simple: who changed the data and when
  • event based audit to a separate table - who did what and when
  • field-level audit - what did the whole data look like before a change and what does it look like now
• you also need to consider who will want to view that audit, when and how - it's all very well to use trigger-based copies of the data but if you can't surface that to a specific role in a timely and easy-to-understand format then the functionality doesn't meet the requirements 
• each of the above levels of sophistication requires different solutions, both to record the changes and also to present them