Skip to navigation

Available comparison operators

View as Markdown

Provides available comparison operators for the condition builder, including value examples.

In a condition, the comparison operator checks the values in the Field and Value fields and returns a boolean value.

The following table lists all supported comparison operators and examples:

OperatorExample of the Field fieldExample of the Value field
Is equal toChange TypeUPDATE
Is not equal toChange TypeDELETE
Is greater than(Invoice) Amount1000.0
Is greater than or equal to(Invoice) Amount1000.0
Is less than(Invoice) Amount1000.0
Is less than or equal to(Invoice) Amount1000.0
Starts with(Account) AccountNumberA
In or match(Account) BatchBatch8, Batch9
Is null(Account) CrmId(N/A)
Is not null(Account) CrmId(N/A)
Is empty(Account) Notes(N/A)
Is not empty(Account) Notes(N/A)