Supported `$filter`
The following operators are supported:
| Operator | Example(s) | Explanation | Standard OData operator |
|---|---|---|---|
and |
Name eq 'ES' and Value eq 14 |
Yes | |
eq |
Name eq 'SomeName'Value eq 2
|
Equals | Yes |
lt |
Value lt 610 |
Less than | Yes |
gt |
Value gt 610 |
Greater than | Yes |
ge |
Value ge 610 |
Greater than or equal to | Yes |
le |
Value le 610 |
Less than or equal to | Yes |
ne |
Name ne 'EXPORT'
|
Different from (not equal) | Yes |
endswith
|
endswith(Name,'RT')
|
Returns all records where name ends with. | Yes |
startswith
|
startswith(Name, 'S')
|
Returns all records where name starts with. | Yes |
contains
|
contains(Name, 'urn')
|
Returns all records where name contains. | Yes |
in
|
Name in ('name1', 'name2')
|
Returns all records where name is exactly on of the given values. | No |
not_in
|
Name in ('name1', 'name2')
|
Returns all records where name is exactly on of the given values. | No |
isnull
|
Value isnull
|
Returns all records where value is null. | No |
isnotnull
|
Value isnotnull
|
Returns all records where value is not null. | No |
isempty
|
Name isempty
|
Returns all records where name is empty, i.e. null or ''. | No |
isnotempty
|
Name isnotempty
|
Returns all records where name is not empty, i.e. not null or ''. | No |
template
|
CreatedBy template '!me'
|
Returns all records where CreatedBy is the currently signed in user. | No |