...
Data types (Work Pending)
Array
Currency
In the filter field, we are using two main operators:
AND: The logical AND operator is an operator that performs a logical combination of two statements. It receives the value "true" only when both statements are true. If one of the two statements is false, the logical AND operator returns the value "false".
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:
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.
Start With:
It returns TRUE if a string or number starts with the specified character otherwise it returns FALSE
Contains:
The contains operator returns TRUE if the value on the left contains the value on the right, and otherwise FALSE.
End With:
It returns TRUE if a string or number ends with the specified character otherwise it returns FALSE
IN:
IN operator allows you to easily test if the expression matches any value in the list of values.
Determines whether the value of an expression is equal to any of several values in a specified list.
Greater Than:
Returns True if the value on the left side is greater than the value on the right side.
Less Than:
Returns True if the value on the left side is less than the value on the right side.
Greater Than or Equal To:
Returns True if the value on the left side is greater than equal to the value on the right side.
Less Than or Equal To:
Returns True if the value on the left side is less than equal to the value on the right side.
Match:
MATCH operator to compare a string expression with a pattern.