Skip to content

Filters

Robert Klohr edited this page Jan 10, 2021 · 4 revisions

Filters

Field aliases in filters are case sensitive.

User and Group Filters

Field Filter Types Usable Values
Active 5 - EqualTo
6 - NotEqualTo
True
False
Deleted 5 - EqualTo
6 - NotEqualTo
True
False
AccountType 5 - EqualTo
6 - NotEqualTo
10002 - ContainsAny
1, Full, FullUser
2, Vendor, VendorContact, VendorContactUser
4, Awareness, AwarenessUser

Record Filters

Filter Type


ID Filter
1 Contains
2 Excludes Null
3 Starts With
4 Ends With
5 =
6 <>
7 >
8 <
9 >=
10 <=
11 Between
12 Not Between
13 Is Empty
14 Is Not Empty
15 Is Null
16 Is Not Null
10001 Offset
10002 Contains Any
10003 Contains Only
10004 Contains None
10005 Contains At Least
Clone this wiki locally