Operators available for filters and queries
-
- UpdatedJan 30, 2025
- 11 minutes to read
- Yokohama
- Navigation and UI
The system provides a set of operators for use with filters, condition builders, and encoded queries. The data type of a field determines what operators are available for it.
Operators available for condition builders
Operator label | Example condition | Equivalent query operator | Example query | Example output |
---|---|---|---|---|
AND | [Active][is][True][AND][Caller][is not empty] | ^ | active=true^CallerISNOTEMPTY | All records that have both of the following:
|
OR condition | [Short description][is empty][OR][Description][is empty] | ^OR | short_descriptionISEMPTY^ORdescriptionISEMPTY | All records that have at least one of the following:
|
OR filter |
All these conditions must be met [Short description][is empty] OR all these conditions must be met [Description][is not empty] |
^NQ new query |
short_descriptionISEMPTY^NQdescriptionISNOTEMPTY | All records that have at least one of the following:
|
Operators available for string fields
Operators available for reference fields
Note: Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators.
Operators available for choice fields containing strings
Operators available for choice fields containing integers
Note: The operators ‘less than or is’ and ‘greater than or is’ are not supported for integer fields in the condition builder. Use a scripted condition instead.
Operators available for date-time fields
Operators available for numeric fields
Operators available for Boolean fields
Operators available for email notifications
Operator label | Example condition | Equivalent query operator | Example query | Example output |
---|---|---|---|---|
changes | [State][changes] | VALCHANGES | stateVALCHANGES | All records in which the State field is updated. |
changes from | [State][changes from][Awaiting User Info] | CHANGESFROM | stateCHANGESFROM4 | All records in which the State field is updated to another value after previously being Awaiting User Info (4). |
changes to | [State][changes to][Awaiting User Info] | CHANGESTO | stateCHANGESTO4 | All records in which the State field is updated to Awaiting User Info (4) after previously being any other value. |
Operators available for tags
Operator label | Example condition | Equivalent query operator | Example query | Example output |
---|---|---|---|---|
have | [Tag][have][Most Active] | = | sys_tags.6c361e12471331007f47563dbb9a7135=6c361e12471331007f47563dbb9a7135 | All records that have the Tag in the value field. |
does not have | [Tag][does not have][Most Active] | DOESNOTHAVE | sys_tags.6c361e12471331007f47563dbb9a7135DOESNOTHAVE6c361e12471331007f47563dbb9a7135 | Any records that has a Tag except for the tag mentioned in the value field. |
excluding | [Tag][excluding][Most Active] | EXCLUDING | sys_tags.6c361e12471331007f47563dbb9a7135EXCLUDING6c361e12471331007f47563dbb9a7135 | All records with and without the Tag except for the tag mentioned in the value field. |
On this page
- Operators available for condition builders
- Operators available for string fields
- Operators available for reference fields
- Operators available for choice fields containing strings
- Operators available for choice fields containing integers
- Operators available for date-time fields
- Operators available for numeric fields
- Operators available for Boolean fields
- Operators available for email notifications
- Operators available for tags
Related Content
- Condition builder
A condition builder constructs a condition statement with a series of contextually generated fields. Condition builders are used in many operations, such as creating filters, administering surveys, and administering access control.