Formula operators
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.
|
String operators
Contains
Does Not Contain
Is
Is Not
Value operators
<
<=
>
>=
==
!=
Connector operators
&
|