...
Data types (Work Pending)
Array
Currency
...
Logical Operators
Logical operators are used to combine multiple conditions.
AND: The logical AND operator is an operator that performs a logical combination of two statements. It receives the value "trueTRUE" only when both statements are true. If one of the two statements is false, the logical AND operator returns the value "falseFALSE".
OR: The OR operator is a Boolean operator that returns TRUE or a Boolean value of 1 if one or both operands are TRUE or a Boolean value of 1.NOT:
NOT: Operators that can be used to create a new compound statement from two or more statements. It reverses the truth value of any statement it appears before.
Filter Operators
Equals:
The equal operator is used to compare two values or expressions. It is used to compare numbers, strings, Boolean values, variables, objects, etc. The result is TRUE if the expressions are equal otherwise it's FALSE.
...
Returns True if the value on the left side is less than equal to the value on the right side.
Match:
MATCH Match operator to compare a string expression with a pattern. returns true or false depending on whether its pattern matches the given string. The match operator supports these wildcard characters in the quoted string. Matches any of the enclosed characters, including ranges, as in [ a-z ].