system.util.queryAuditLog targetFilter wildcard

Ignition
, ,
1

Similar to this post, I would like to use a filter on action_target with a wildcard.

This works

system.util.queryAuditLog(auditProfileName='Audit', targetFilter='%MyTP]My/Tag/Something%')

but this doesn't

system.util.queryAuditLog(auditProfileName='Audit', targetFilter='%[MyTP]My/Tag/Something%')

Basically, if I remove the first [ from the tag provider and include the % it works, with the bracket and with or without % does not. I copied the value directly from the table so I know it's correct.

Any ideas?
On 8.1.35

2

Regex syntax, perhaps? Try a pair of backslashes in front of the left bracket.

3

That didn't seem to work for me either.

4

This wasn't anything related to Ignition, rather the database, which sadly enough for my project is MSSQL. Most likely other databases like MySql, Postgres, won't run into this issue but I don't have them installed to check.

So, dropping the first bracket or doing as they suggest in these links will work.