...
The Between operator selects values within a given range. The values can be numbers, text, or dates. The Between operator is inclusive: begin and end values are included.
All Of: If all records are filter which are present in input
All of operator is used to compare each value to another value. The all of operator returns TRUE if all values match the given condition.
None Of: If all record which are present in input should not get filterAny Of: If any one or more records are fetch present in input
None of operator is used to compare each value with another value. None of the operators returns TRUE if all values do not match the given condition.
Any Of:
Any of operator is used to compare each value with another value. Any of operator returns TRUE if any one value matches the given condition.
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 ].
...