Question
Field level auditing
Hello everyone,
we have the following requirement where, instead of using the OOTB visual representation of audit history we would like to show the audit in the below format.
We are planing to use OOTB field level auditing capability using pyTrackSecurityChanges declare trigger.
Date/Time | Field Name | Orginal Value | Changed Value | User |
12-Jun | Account Number | AAAAA | BBBBB | Rebecca |
13-Jun | Account Number | BBBBB | CCCCC | James |
| Corporate.List |
|
|
|
| Corporate.Group |
|
|
|
Has anyone done a similer implementation? or any idea on how to achieve this would be greatly appriciated.
Auditing is recorded in History table
if you use OOTB activity TrackSecurityChanges - system will store property name in PYLABEL column and values (original and change) values in PYMEMO column. From these columns you are able to get the details.
Just try with operator id table, you are able to understand
Create declare trigger under class Data-Admin-Operator-ID , in the trigger call the activity TrackSecurityChanges.
Now open your operator id and change the position from profile tab.
validate entry in table pr_history_data
reference : https://community.pega.com/knowledgebase/articles/security/how-audit-field-level-changes-security-rule-and-data-instances