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 ⊆.

Images

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".

Images

Next steps