Operator | Syntax | Description | |
! | ! expr | Negates the next expression. | |
This example... | Evaluates to true if... | ||
! (%sku% = "WM001") | The value of the sku variable is not equal to WM001. | ||
not | not expr | Negates the next expression. | |
This example... | Evaluates to true if... | ||
not (color = "blue") | The color variable is not equal to blue. | ||
| | expr | expr | Logical *OR. True if either of the expressions is true. | |
This example... | Evaluates to true if... | ||
%color% = "blue" | %color% = "red" | The value of the color variable is blue or red. | ||
|| | expr || expr | Logical OR. True if either of the expressions is true. | |
This example... | Evaluates to true if... | ||
totalPrice > 1000 || customerID = 'Favorite Customer' | The value of the totalPrice variable is greater than 1000 or the value of the customerID variable equals Favorite Customer. | ||
or | expr or expr | Logical OR. True if either of the expressions is true. | |
This example... | Evaluates to true if... | ||
creditCardNum = $null or cardExpireDate = $null or cardExpireDate <= orderDate | The value of the creditCardNum variable is null or missing or if the value of the cardExpireDate variable is null or missing or if the value of the cardExpireDate variable is less than or equal to the value of the orderDatevariable. | ||
& | expr & expr | Logical AND. Both expressions must evaluate to true for the entire condition to be true. | |
This example... | Evaluates to true if... | ||
%customerID% = 'Favorite Customer' & %sku% = 'WM001' | The value of the customerID variable is Favorite Customer and the value of the sku variable is WM001. | ||
&& | expr && expr | Logical AND. Both expressions must evaluate to true for the entire condition to be true. | |
This example... | Evaluates to true if... | ||
quantity >= 20 && totalPrice >= 100 | The value of the quantity variable is greater than or equal to 20 and the value of the totalPrice variable is greater than or equal to 100. | ||
and | expr and expr | Logical AND. Both expressions must evaluate to true for the entire condition to be true. | |
This example... | Evaluates to true if... | ||
!color and !size | The color variable does not exist in the input or is null and the size variable does not exist in the input or is null. |