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
I hope you can use the Declare Trigger to save the caseID as a new column.
@RameshSangili i tried to use the same but its not working
@VivekK16711353 To add an extra property (like caseid) to the FL audit table (FLAudit-Work-**) and populate it with the case ID (e.g., W-15066 from pxHistoryReference), you can create a Declare OnChange or Declare Trigger rule on the FLAudit-Work-** class. This rule will run whenever a new audit entry is created. Inside the activity or data transform, use string manipulation (e.g., @substring, @indexOf) or a regular expression function to extract the case ID from the pxHistoryReference value. Then set that extracted value to your custom caseid property. This way, every time a new row is added to the audit table, the caseid field gets automatically populated and is available for BIX extraction. Make sure the caseid property is exposed in the database schema if you want to query it efficiently.