Rule Operators

Logical operators let you set a sequence for evaluating conditions. Comparison operators let you select a function to compare the value of a field to a specific value, the value of another field, or the value of an application variable.

Restriction:

In field-to-field comparisons, you can only select fields that are suitable to a given field type. For a list of supported field types, see Field-to-Field Comparisons.
You can only select comparison operators that are suitable for a given field type. For example, you can select a > operator for a Numeric field, but not for a Multi-User field. For a list of supported operators, see Field Comparison Operators.

Logical Operators

The following table describes the AND and OR logical operators.

Operator	Description
AND	Drag AND from the Logical Operators section of the Rule Palette onto the expression. A rule using this operator evaluates as "true" when all expressions it joins evaluate to "true." For example, the condition "Amount > 100 " AND "Amount <= 500" evaluates whether the Amount field value is between 101 and 500.
OR	Drag OR from the Logical Operators section in the Rule Palette onto the condition. A rule using this operator evaluates as "true" when any expression it joins evaluates to "true." For example, the conditions "Owner in Joe Manager" OR "State in New" evaluates whether the item is in the "New" state or is owned by Joe Manager.

Comparison Operators

The following table describes the comparison operators.

Operator	Description
= (equal to)	An expression using this operator will evaluate to "true" if the value of the field on the left is the same as the value on the right.
> (greater than)	An expression using this operator will evaluate to "true" if the value of the field on the left is greater than the value on the right.
< (less than)	An expression using this operator will evaluate to "true" if the value of the field on the left is less than the value on the right.
>= (greater than or equal to)	An expression using this operator will evaluate to "true" if the value of the field on the left is greater than or equal to the value on the right.
<= (less than or equal to)	An expression using this operator will evaluate to "true" if the value of the field on the left is less than or equal to the value on the right.
<> (not equal to)	An expression using this operator will evaluate to "true" if the value of the field on the left is not the same as the value on the left.
in	An expression using this operator will evaluate to "true" if the field on the left contains one or more of the values specified on the right.
not in	An expression using this operator will evaluate to "true" if the field on the left does not contain any of the values specified on the right.
contains all	An expression using this operator will evaluate to "true" if the field on the left contains all of the values specified on the right.
contains any	An expression using this operator will evaluate to "true" if the field on the left contains any of the values specified on the right.
does not contain all	An expression using this operator will evaluate to "true" if the field on the left does not contain all of the values specified on the right.
does not contain any	An expression using this operator will evaluate to "true" if the Multi-Selection or Multi-User field on the left does not contain any of the values specified on the right.
contains	An expression using this operator will evaluate to "true" if the field contains the specified text.
like	An expression using this operator will evaluate to "true" if the first field on the left matches the specified wildcard expression.
not contains	An expression using this operator will evaluate to "true" if the Text field on the left does not contain the specified text.
not like	An expression using this operator will evaluate to "true" if the field on the left does not match the specified wildcard expression.
like (zero-filled)	An expression using this operator will evaluate to "true" if the field on the left matches the specified wildcard expression, including leading zeroes. For example, if there are leading zeroes on an Item ID number, they do not have to be specified for the expression to evaluate as "true."
is empty	An expression using this operator will evaluate to "true" if the field value is empty (in which values have not been entered or not provided by a user).
is not empty	An expression using this operator will evaluate to "true" if the field value is not empty (in which values have been provided).

Rule Operators

Logical Operators

Comparison Operators

Related Topics