The tool provides the following operators to create a filtering formula. Operators are processed in order of precedence. Operators of equal precedence are evaluated in left-to-right order. Brackets override the processing order. A categorization of the operators is listed after the table.
Operator
Precedence
Unary
Usage Details
Contains
1
No
Facilitate “String containing a substring” scenario, e.g., “RoomName Contains office”
Both operands must be a string.
Return 1 if the right operand is a substring of the left operand. Otherwise return 0.
Does Not Contain
1
No
Opposite of Contains.
Returns 1 if the right operand is not a substring of the left operand. Otherwise returns 0.
Is
1
No
Allow string comparison scenario.
Both operands must be a string.
Return 1 if both operands are the same string. Otherwise return 0.
Is Not
1
No
Opposite of Is.
Returns 1 if both operands are different strings. Otherwise returns 0.
&
3
No
AND Logic operator which connects two formulae.
Return 1 if both formula is evaluated to 1, otherwise return 0.
|
4
No
OR Logic operator which connects two formulae.
Return 1 if either of the two formula is evaluated to 1, otherwise return 0.
<
2
No
“Is less than” logical operator. Returns 1 if true, 0 if false.
<=
2
No
“Is less than or equal” logical operator. Returns 1 if true, 0 if false.
>
2
No
“Is greater than” logical operator. Returns 1 if true, 0 if false.
>=
2
No
“Is greater than or equal” logical operator. Returns 1 if true, 0 if false.
==
2
No
“Is equal” logical operator. Returns 1 if true, 0 if false.
!=
2
No
“Is not equal” logical operator. Returns 1 if true, 0 if false.
