Filtering operators

Operator	Reverse Operator	Parameters	Type compatibility	Description
EQUALS	NOT_EQUALS	1	Text, Number, Boolean	Equal/not equal to the value.
STARTS_WITH	NOT_STARTS_WITH	1	Text	The text starts/does not start with characters.
STARTS_WITH_DIGIT	/	Optional	Text	The text starts with a digit. The optional parameter is a pair of upper and lower boundaries separated by a comma. For example, "3, 8" means any digit from 3 to 8 is included.
ENDS_WITH	NOT_ENDS_WITH	1	Text	The text ends/does not end with characters.
INCLUDES	NOT_INCLUDES	1	Text	The text contains/does not contain the characters.
LESS	GREATER	1	Number	The value is strictly less than/greater than the value.
LESS_OR_EQUALS	GREATER_OR_EQUALS	1	Number	The value is less than or equal to/greater than or equal to the value.
BETWEEN	/	2	Number	The value is included within the values.
NULL	NOT_NULL	None	Text, Number, Boolean	Absence/presence of value.
IN	NOT_IN	Collection	Text, Number, Boolean	The value is in/not in the set of values.
EXISTS	NOT_EXISTS	1 (optional)	n/a	See below.
CR_FILTER_DOMAIN	/	1	n/a	ComplexRelation specific filter. Includes only complex relations with at least one related asset in the domain.

The following table shows samples for each operator.

Operator	Example
EQUALS	{ "Field": { "name": "domainName", "operator": "EQUALS", "value": "New Business Terms" } }
STARTS_WITH	{ "Field": { "name": "domainName", "operator": "STARTS_WITH", "value": "New" } }
STARTS_WITH_DIGIT	{ "Field": { "name": "assetName", "operator": "STARTS_WITH_DIGIT" } }
ENDS_WITH	{ "Field": { "name": "domainName", "operator": "ENDS_WITH", "value": "Terms" } }
INCLUDES	{ "Field": { "name": "domainName", "operator": "CONTAINS", "value": "Bus" } }
LESS	{ "Field": { "name": "lastModified", "operator": "GREATER", "value": "1440492290300" } }
LESS_OR_EQUALS	{ "Field": { "name": "lastModified", "operator": "GREATER_OR_EQUALS", "value": "1440492290300" } }
BETWEEN	{ "Field": { "name": "lastModified", "operator": "BETWEEN", "values": [ "1440492290300", "1440493000000" } }
NULL	{ "Field": { "name": "description", "operator": "NULL" } }
IN	{ "Field": { "name": "statusName", "operator": "IN", "values": [ "New", "In Review" ] } }
EXISTS	{ "Field": { "target": "RelationSource", "operator": "EXISTS", "value": "00000000-0000-0000-0000-000000007001", "name": "assetId" } }
CR_FILTER_DOMAIN	{ "Field": { "operator": "CR_FILTER_DOMAIN", "value": "00000000-0000-0000-0000-000000006013" } }

EQUALS and IN filters are by default a case sensitive. You can make the filter case insensitive by setting the caseInsensitive flag to true in the filters body:

"Field": { "name": "FullName", "operator": "IN", "caseInsensitive": true, "values": [ "normal", "data quality eDitor" ] }

The query matches the lowercase full name to the lowercase values from the values section.