Filter by "Not Like" in Aggregate

Filter by "Not Like" in Aggregate

I am able to filter by "like" in an aggregate.  This statement works:
AuditRequest.Attribute like "%Id%"

I am not able to use "not like".  This statement causes an "Unexpected 'not' in expression" error:
AuditRequest.Attribute not like "%Id%"

What syntax should I use in an aggregate to filter by not like?


You cannot use the "not like" operator in Aggregates:

You can use it within a SQL element if you must use the Not Like expression.
I discovered that you can use "not" with "like".  Instead of "not like", use not(

Here is an example:
not(AuditRequest.Attribute like "%Id%")

Thanks for the tip Karen, very useful!