Skip to main content

The operators

The following table lists the operators available in basic mode.

Text operators available in basic mode
Operator name Example and details
is CustomerName is Smith
is not FirstName is not John
contains StatusCode contains 0AZ
does not contain ItemID does not contain X32
starts with BankNumber starts with FR
does not start with ItemID does not start with DE123
ends with BankNumber ends with 0089
does not end with BankNumber does not end with Y9
matches regex PostalCode matches regex ^[0-9]{5}(-[0-9]{4})?$
does not match regex SSN does not match regex ^\\d{3}-\\d{2}-\\d{4}$
is of type Location is of type Asia

Select a semantic type or standard type: boolean, date, decimal, or integer.

is empty DriverLicense is empty
Number operators available in basic mode
Operator name Example and details
is equal to Age is equal to 21
is not equal to CustomerID is not equal to 16742
is greater than Age is greater than 17
is greater than or equal to Age is greater than or equal to 21
is less than Age is less than 16
is less than or equal to Age is less than or equal to 20
Date and time operators available in basic mode
Operator name Example and details
is equal to DateOfReceipt is equal to 2020-05-14 09:55:00
You can select a date or a time, or both. The supported formats are:
  • yyyy-mm-dd
  • hh:mm:ss
  • yyyy-mm-dd hh:mm:ss
is not equal to ValidationDate is not equal to 2020-09-02
You can select a date or a time, or both. The supported formats are:
  • yyyy-mm-dd
  • hh:mm:ss
  • yyyy-mm-dd hh:mm:ss
is before BirthDate is before 2003-12-16
You can select a date or a time, or both. The supported formats are:
  • yyyy-mm-dd
  • hh:mm:ss
  • yyyy-mm-dd hh:mm:ss
is before or equal to ExpiryDate is before or equal to 2002-01-01
You can select a date or a time, or both. The supported formats are:
  • yyyy-mm-dd
  • hh:mm:ss
  • yyyy-mm-dd hh:mm:ss
is after BirthDate is after 1983-12-31
You can select a date or a time, or both. The supported formats are:
  • yyyy-mm-dd
  • hh:mm:ss
  • yyyy-mm-dd hh:mm:ss
is after or equal to BirthDate is after or equal to 1971-01-01
You can select a date or a time, or both. The supported formats are:
  • yyyy-mm-dd
  • hh:mm:ss
  • yyyy-mm-dd hh:mm:ss
is in (month) HireDate is in month March
is on (day of the week) PublicationDate is on day of the week Friday
is on (day of the month) PublicationDate is on day of the month 16

Boolean operators available in basic mode
Operator name Example and details
is true Validity is true
is false Validity is false
is equal to Access is equal to Validity

Use this operator to compare two variables of boolean type.

is not equal to Access is not equal to Validity

Use this operator to compare two variables of boolean type.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!