Previous value with async business rule

[emaasalmi]

Hi experts,

as I've understood, the "previous.fieldName" does not work in an async business rule. What would then be the best way to find the current Incident's previous assignment group in an async business rule? Should I just do a gliderecord query to sys_audit using the current Incident's sysid and current assignment group as the new value to get the old value, or is there a more efficient way to achieve this? As the sys audit hold massive amount of records, this seems like a heavy operation. This also requires me to do another lookup to groups table as the sys_audit only displays the sysid of the assignment group and I need the display value.

I have no power over creating a new field for saving the previous value, so that' out of the question.

[BALAJI40]

Yes previous object is not available for Async business rule.

As you said, sys_audi holds large amount of data, The only way was creating new filed or create new table which holds similar information and you can Glide record this table in async BR.

write a business rule to update your date in new table on incident table.