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

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

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

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.

Operators available for tags

Table 10. 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.