The operators
The following table lists the 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 |
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 |
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:
|
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:
|
is before |
BirthDate
is before
2003-12-16
You can select a date or a time, or both. The supported formats are:
|
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:
|
is after |
BirthDate
is after
1983-12-31
You can select a date or a time, or both. The supported formats are:
|
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:
|
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 |
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. |