Valid Operators
The following operators are available for use with the /runquery endpoint.
AND: Combines two conditions and returns true only if both conditions are true. See: Combining AND, OR, and BETWEEN
OR: Combines two conditions and returns true if either of the conditions is true. See: Combining AND, OR, and BETWEEN
IS_NULL: Returns true when the value of the column is null.
IS_NOT_NULL: Returns true when the value of the column is not null.
EQUALS: Returns true when the value for the column is equal to the value provided in in the query.
NOT_EQUALS: Returns true when the value for the column is not equal to the value provided in the query.
GREATER_THAN: Returns all rows with values in the column greater than the value provided in the query.
GREATER_THAN_OR_EQUALS: Returns all rows with values in the column greater than or equal to the value provided in the query.
LESS_THAN: Returns all rows with values in the column less than the value provided in the query.
LESS_THAN_OR_EQUALS: Returns all rows with values in the column less than or equal to the value provided in the query.
BETWEEN: Returns all rows with values in the column greater than or equal to the values provided in the query. See: Combining AND, OR, and BETWEEN
LIKE: Returns all rows with values in the column between the values provided in the query. See: Using LIKE and IN
IN: Returns all rows with values in the column matching one of the values provided in the comma-separated list by the user. See: Using LIKE and IN