filter
argument. This makes it easy to retrieve specific information, like any threads assigned to a particular user, but much more complex queries are also possible.
For example, to return all open threads that are assigned to a particular user, you can use the following query:
Operation | Description | Type |
---|---|---|
BETWEEN | Between two given values. | [string, string] |
IN | One of the given values. | string[] |
NOT_IN | Not one of the given values. | string[] |
EQUALS | Equal to given value. | [string] |
NOT_EQUALS | Not equal to given value. | [string] |
GREATER | Greater than given value. | [string] |
LESS | Less than given value. | [string] |
GREATER_EQUALS | Greater than or equal to given value. | [string] |
LESS_EQUALS | Less than or equal to given value. | [string] |
LIKE | Like given value. (Accepts the % operator) | [string] |
NOT_LIKE | Not like given value. (Accepts the % operator) | [string] |
ILIKE | Like given value, ignoring case. (Accepts the % operator) | [string] |
NOT_ILIKE | Not like given value, ignoring case. (Accepts the % operator) | [string] |
CONTAINS | Contains given value. | [string] |
NOT_CONTAINS | Not contains given value. | [string] |
ICONTAINS | Contains given value, ignoring case. | [string] |
NOT_ICONTAINS | Not contains given value, ignoring case. | [string] |
STARTS_WITH | Starts with given value. | [string] |
DOES_NOT_START_WITH | Not starts with given value. | [string] |
ARRAY_CONTAINS | Array contains given value. | [string] |
NULL | The value of the field must be null. | [] |
NOT_NULL | The value of the field must not be null. | [] |
ARRAY_EMPTY | Array is empty. | [] |
ARRAY_NOT_EMPTY | Array is not empty. | [] |
or
keyword that lets you switch to a logical or operator. For example, to find all threads that were created before a specific timeframe or are assigned to a particular user, you can use the following query: