Skip to content
View as Markdown

Operator

Name Number Description
EQUAL 0 The operator supports a list of the elements on the right side. The API supports a single string as the value on the right side of the operator so we follow a convention when you can provide multiple values in a single string by separating them with a '~~' string. When a list of values is provided, this is equivalent to a logical IN
NOT_EQUAL 1 The operator supports a list of the elements on the right side. The API supports a single string as the value on the right side of the operator so we follow a convention when you can provide multiple values in a single string by separating them with a '~~' string. When a list of values is provided, this is equivalent to a logical NOT IN
GREATER_THAN 2
GREATER_THAN_OR_EQUAL 3
LESS_THAN 4
LESS_THAN_OR_EQUAL 5
WILDCARD 6 A simplified regex syntax, where '*' is the wildcard character and '?' matches a single character and there are no other special characters. Matches are always made against the entire string. If the string contains only a leading and trailing wildcard, this will be evaluated as CONTAINS.
NOT_WILDCARD 7 A negation of the WILDCARD operator.
IN 9 Explicitly matches the field against a list of values, with a logical IN. The API supports a single string as the value on the right side of the operator so we follow a convention when you can provide multiple values in a single string by separating them with a '~~' string.
NOT_IN 10 A negation of the IN operator.