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