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:

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."

Related Topics

Creating Expressions for Rules

Field Options and Values