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.

Table 1. 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:
  • Active field is True
  • Caller field has any value
OR condition [Short description][is empty][OR][Description][is empty] ^OR short_descriptionISEMPTY^ORdescriptionISEMPTY All records that have at least one of the following:
  • Short description field has no value
  • Description field has no value
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:
  • Short description field has no value
  • Description field has no value
Note: Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators.
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.
Table 9. 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.