After Query Business Rule (sys_audit)

[stevejarman]

I'm trying to create a Business Rule that fires after query of sys_audit, when the new value field of the record contains a URL. For some reason though, the Business Rule never fires, even though I'm definitely meeting the conditions. Can anyone think of any reason why it wouldn't work?

I've tried just setting the script to nothing but a gs.log and the message never appears in the log.

[Pradeep Sharma]

Hello Steve,

To prevent performance issues and infinite loops, the system skips any business rule or workflow triggered by inserts to the Sys Audit table. It is documented here.

The Sys Audit table

[stevejarman]

"Triggered by inserts". What I'm trying to do though is apply a Business Rule "after query" of sys_audit.

Is the documentation just not specific enough and it actually prevents ALL Business Rules against sys_audit?

[Pradeep Sharma]

Thanks for the update Steve. Let me test and get back to you on this.

[Pradeep Sharma]

Hello Steve,

Can you flip it to before and it will work. Ideally, I don't think AFTER query will be triggered as the records are already rendered. In my testing, this is the same case for all other tables.

P.S: This is the case for only ONLY AFTER QUERY CHECKBOX SELECTED.