Using Security - Audit Log Function on Table to filter Audit Log

Ignition
1

Hello,

Looking for a little guidance on the following.

image
image994×691 39.2 KB

If I pass parameters for say Actor filter, what value would I need to set it to in order to return all actors vs a single actor.

Thanks,

Frank

2

I think through some testing I have arrived at one solution. As long as the parameter values are blank it returns everything. Unless there is a better way to do this I will stick with it.

3

Leaving blank is fine, or you can use a SQL wildcard - %; ultimately, the actor filter you provide makes its way into a SQL LIKE clause in the query given to the database:
https://www.w3schools.com/sql/sql_like.asp