...
Operation | Description | Example returning TRUE |
---|---|---|
== | Checks if two values are equal. Returns true if they are, false otherwise. |
|
!= | Checks if two values are not equal. Returns true if they are not, false otherwise. |
|
> | Checks if the left value is greater than the right value. Returns true if it is, false otherwise. |
|
>= | Checks if the left value is greater than or equal to the right value. Returns true if it is, false otherwise. |
|
< | Checks if the left value is less than the right value. Returns true if it is, false otherwise. |
|
<= | Checks if the left value is less than or equal to the right value. Returns true if it is, false otherwise. |
|
CONTAINS | Checks if a text value contains a specified substring. Returns true if it does, false otherwise. |
|
STARTSWITH | Checks if a text value starts with the specified substring. For example Returns true if it does, false otherwise. |
|
LIKE | Performs a pattern matching comparison between a text value and a specified pattern. Returns true if the pattern matches, false otherwise. |
|
NOT | Negates the Boolean value of an expression. Returns true if the expression is false, false if it is true. |
|
ISBLANK | Checks if a field or expression is blank (empty) or null. Returns true if it is blank, false otherwise. Example: |
|
[index] | Array index operator. Returns the element at the specified index in a list (starting with zero). For example |
|
...