Skip to main content

Compare

Equal to (=)​

Description

Checks if the first field or expression value is equal to the second value.

  • Returns true if the field or expression values are equal.
  • Returns false if the values are not equal.

Syntax

<Comparison field or Expression> = <Comparison field or Expression>

Supported values

All values can be used. Both values must be of the same kind.

NULL handling

If you use an Equal to (=) comparison with NULL, the result is always NULL or unknown, not true or false.

Example

Actual date = Expected date

Greater than or equal to (>=)​

Description

Checks if the first field or expression value is equal to or greater than the second value.

  • Returns true if the first field or expression value is greater than or equal to the second value.
  • Returns false if the first value is less than the second value.

Syntax

<Comparison field or Expression> >= <Comparison field or Expression>

Supported values

All values can be used. Both values must be of the same kind.

NULL handling

If you use an Greater than or equal to (>=) comparison with NULL, the result is always NULL or unknown, not true or false.

Example

Actual date >= Expected date

Greater than (>)​

Description

Checks if the first value is greater than the second value.

  1. Returns true if the first field or expression value is greater than the second value.
  2. Returns false if the first value is equal to or less than the second value.

Syntax

<Comparison field or Expression> > <Comparison field or Expression>

Supported values

All values can be used. Both values must be of the same kind.

NULL handling

If you use an Greater than (>) comparison with NULL, the result is always NULL or unknown, not true or false.

Example

Actual date > Expected date

Less than or equal to (<=)​

Description

Checks if the first field or expression value is equal to or less than the second value.

  • Returns true if the first field or expression value is less than or equal to the second value.
  • Returns false if the first value is greater than the second value.

Syntax

<Comparison field or Expression> <= <Comparison field or Expression>

Supported values

All values can be used. Both values must be of the same kind.

NULL handling

If you use an Less than or equal to (<=) comparison with NULL, the result is always NULL or unknown, not true or false.

Example

Actual date <= Expected date

Less than (<)​

Description

Checks if the first field or expression value is less than the second value.

  • Returns true if the first field or expression value is less than the second value.
  • Returns false if the first value is equal to or greater than the second value.

Syntax

<Comparison field or Expression> < <Comparison field or Expression>

Supported values

All values can be used. Both values must be of the same kind.

NULL handling

If you use an Less than or equal to (<=) comparison with NULL, the result is always NULL or unknown, not true or false.

Example

Actual date < Expected date

Not equal to (!=)​

Checks if the first field or expression value is not equal to the second value.

  • Returns true if the values are not equal.
  • Returns false if the first value is equal to the second value.

Syntax

<Comparison field or Expression> != <Comparison field or Expression>

Supported values

All values can be used. Both values must be of the same kind.

NULL handling

If you use an Not equal to (!=) comparison with NULL, the result is always NULL or unknown, not true or false.

Example

Actual date != Expected date

IN​

Description

Checks if the first field or expression value matches one of the values in a specified list.

  • Returns true if the field or expression value matches either one of the expression, field, or contant values specified in a list values.
  • Returns false if the field or expression value matches none of the specified values.

Syntax

<Field or Expression> IN <Expression or Field or Constant> [+<Expression or Field or Constant> + ...]

Supported values

All values can be used. Values must be of the same kind.

NULL handling

If the first input field or expression is NULL, the result is NULL. NULL values in the list of values are not taken into account.

Example

Activity IN ("Create purchase order", "Create purchase order item"

IS NULL​

Description

Checks if a field or expression value is NULL.

  • Returns true if the field or expression value is NULL.
  • Returns false if the value is not NULL.

Syntax

<Field or Expression> IS NULL

Supported values

All values can be used.

NULL handling

N/A

Example

Automated IS NULL

IS NOT NULL​

Description

Checks if a field or expression value is not NULL.

  1. Returns true if the field or expression value is not NULL.
  2. Returns false if the value of is NULL.

Syntax

<Field or Expression> IS NOT NULL

Supported values

All values can be used.

NULL handling

N/A

Example

Automated IS NOT NULL