How to implement Field level Audit Track for reference data type field in case work type
In case field is defined at case work type we use the OOTB Case Management-Workmanagement-FieldAuditingType to get the audit trail. For scenario a Pagelist using SOR pattern i.e referening a data type,how to implement field level tracking for each column ? Our approach should be customizing pyTrackSecurityChanges Data Transform and the respective declare trigger pyTrackSecurityChanges ?what about writing database trigger in DB space ?
SOR Pattern type data access only refers the data from external source, it won't persist within the case as against to Snapshot pattern. While using SOR pattern there won't be data instance changes which can be tracked with a declare trigger rule. I think you would like to track the changes at data source level while it get referred from case.