Question

bitsinglass
bitsinglass
IN
bitsinglass
Posted: 17 hours 51 minutes ago
Last activity: 11 hours 3 minutes ago
Last activity: 29 Apr 2025 12:46 EDT
How to add extra property to FL audit table
Hi
we have field level auditing enabled for statuswork property,
instances of FLAudit-work-** table, has pxHistoryReference column, its value is "HISTORY-**-***-WORK-*** **-**-WORK-** W-15066!20220809T210754.839 GMT"
we would like to extract W-15066 from pxHistoryReference and save into another newly created property on FLAudit-work-** which is caseid
This should be updated every time entry in audit table is being made
we want to use this property in BIX report which we generating on audit class