Applications → Defining Rules → Working with Rules → Creating Expressions for Rules → 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.
| 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. |
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." |
Copyright © 2007–2016 Serena Software, Inc. All rights reserved.