Question
bitsinglass
IN
Last activity: 17 May 2025 23:55 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
Accepted Solution
Updated: 17 May 2025 23:55 EDT
HCA Healthcare
US
Pegasystems Inc.
CA
bitsinglass
IN
@RameshSangili i tried to use the same but its not working
Accepted Solution
Updated: 17 May 2025 23:55 EDT
HCA Healthcare
US
@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.
@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-15066frompxHistoryReference), 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 thepxHistoryReferencevalue. Then set that extracted value to your customcaseidproperty. This way, every time a new row is added to the audit table, thecaseidfield gets automatically populated and is available for BIX extraction. Make sure thecaseidproperty is exposed in the database schema if you want to query it efficiently.