Filter Operators

The following table contains the list of operators you can use in filters.

Table Filter Operators

Operator	Description
eq	Equal to or in.
neq	Not equal to or not in.
lt	Less than.
gt	Greater than.
ge	Greater than or equal to.
le	Less than or equal to.
bwith	Begins with.
ewith	Ends with.
cany	Contains any. The value parameter can have multiple values, each separated with a plus sign (+). For example, to find Sales Regions 1,3, and 5: &P1=cany&P2=Sales.Region&P3=3+1+3+5
call	Contains all. The value parameter can have multiple values, each separated with a plus sign (+).
like	Like. The value parameter must contain a value and end with the wildcard %25. For example, to find account names that are like Acme: &P1=like&P2=Account.Name&P3=Acme%25
top	Top n items. For example, to find the top 6 sales revenues: &P1=top&P2=Sales.Revenue&P3=6
bottom	Bottom n items. For example, to find the bottom 4 sales revenues: &P1=bottom&P2=Sales.Revenue&P3=4
bet	Between. The value parameter must have two values, separated by plus signs (+). For example, to filter on Sales Region between 3 and 7, use: &P1=bet&P2=Sales.Region&P3=2+3+7
null	Is null (the value parameter must be 0).
nnull	Is not null (the value parameter must be 0).