1. Home
  2. Workflows
  3. Comparison Operators

Comparison Operators

There are multiple jobs in the Workflow Engine that can make use of comparison operators, the most commonly used being “Route from metadata” or the filters in the operations jobs.

We have listed the different operators and how they can be used below.

OperatorComparison true if
==Left side equals right side (case sensitive)
<Left side is less than right side
<=
=<
Left side is less than or equals right side
>Left side is greater than right side
>=
=>
Left side is greater than or equals right side
betweenLeft side can be found between two values, i.e. “b” can be found between “a;c”.
!between
notbetween
Left side can not be found between two values, i.e. “a” cannot be found between “b;c”.
betweennumberLeft side can be found between two numeric values, i.e. “2” can be found between “1;3”.
!betweennumber
notbetweennumber
Left side can not be found between two numeric values, i.e. “1” cannot be found between “2;3”.
isin
is in
Left side is in a string separated by “,” or “;”. Only works for numbers.
notin
isnotin
Left side is not in a string separated by “,” or “;”. Only works for numbers.
beforeLeft side is before right side. Requires date time in both values.
afterLeft side is after right side. Requires date time in both values.
startswith
startswithcase
Left side starts with the value from right side. Case sensitivity is enabled by adding “case”.
!startswith
!startswithcase
Left side does not starts with the value from right side. Case sensitivity is enabled by adding “case”.
endswith
endswithcase
Left side ends with the value from right side. Case sensitivity is enabled by adding “case”.
!endswith
!endswithcase
Left side does not end with the value from right side. Case sensitivity is enabled by adding “case”.
contains
containscase
Left side contains the value from right side. Case sensitivity is enabled by adding “case”.
!contains
!containscase
Left side does not contain the value from right side. Case sensitivity is enabled by adding “case”.
emptyLeft side is empty. Does not require a value on right side.
!emptyLeft side is not empty. Does not require a value on right side.
lengthLeft side contains X amount of characters, X defined by right side.
length<Left side contains less than X amount of characters, X defined by right side.
length>Left side contains more than X amount of characters, X defined by right side.
regexLeft side matches the regex on the right side.

Updated on 2023-11-22

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support