Solved

API filtering syntax for does NOT contain?

Here is my current API query from the api inline docs page (/api/v2/transactions):

filter

creationDateTime:ge('2026-05-01T00:00:00Z') and creationDateTime:le('2026-06-01T00:00:00Z') and user.name:contains('system')

This matches on system, NP.

My issue is in the docs online for filtering, I can’t seem to locate anything about NEGATING the contains.

In my case I want this query to exclude ‘system’ transactions.

Thanks a million!

Best answer by tmaestas

user.name:ne(‘system’) will do what you want (not equal), but I don’t know if you can negate a “contains”.

+3

user.name:ne(‘system’) will do what you want (not equal), but I don’t know if you can negate a “contains”.

Thanks. My mind was so stuck on ‘contains’ I wasn’t seeing the obvious! Greatly appreciated.

Sign up