Filtering operators
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
None
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
None
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)
Not applicable
See below.
CR_FILTER_DOMAIN
None
1
Not applicable
ComplexRelation specific filter. Includes only complex relations with at least one related asset in the domain.
The following table shows samples for each operator.
EQUALS
STARTS_WITH
STARTS_WITH_DIGIT
ENDS_WITH
INCLUDES
LESS
LESS_OR_EQUALS
BETWEEN
NULL
IN
EXISTS
CR_FILTER_DOMAIN
Last updated
Was this helpful?