...
Operation | Description |
---|---|
== | 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 |
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 |
...