Conditional operators
List of Supported Operators and Logical Operators:
Operators
- is - This operator is meant for exact matches and works like the mathematical = operator.
- is not - This is the negated version of the is operator. The mathematical equivalent is ≠.
- contains - This operator is meant for contained strings or patterns. The mathematical equivalent is ⊆.

Logical Operator
Logical operators come into play when there are more than one condition.
- And: For example, "Fetch Customers where name is Bob Smith and city is Orlando".
- OR: For example, "Fetch Customers where name is Bob Smith or city is Orlando".
