Condition | What it Does | Applies on | Example |
is | Matches exactly the specified value. |
| Column: Quantity Value: 10 Example: Selects records where the Quantity column is exactly 10. |
is not | Does not match the specified value. |
| Column: Price Value: 25.50 Example: Selects records where the Price column is not equal to 25.50. |
contains | Contains the specified substring.
|
| Column: Product Name Value: "out of stock" Example: Selects records where the Product Name column contains the substring "apple". |
doesn't contain | Does not contain the specified substring. |
| Column: Description Value: "out of stock" Example: Selects records where the Description column does not contain the substring "out of stock". |
contain word | Contains the specified whole word. |
| Column: Category Value: "Electronics" Example: Selects records where the Category column contains the whole word "Electronics". |
doesn't contain word | Does not contain the specified whole word. |
| Column: Product Name Value: "apple" Example: Selects records where the Product Name column does not contain the whole word "apple". |
length is lower than | Length of the text is less than the specified value. |
| Column: Description Value: 10 Example: Selects records where the length of the text in the Description column is less than 10 characters. |
is empty | field is empty. |
| Column: Comments Example: Selects records where the Comments column is empty. |
is not empty | field is not empty |
| Column: Customer Name Example: Selects records where the Customer Name column is not empty. |
is date | Matches exactly the specified date |
| Column: Order Date Value: 10/10/2021 Example: Selects records where the Order Date column equals 10/10/2021 |
is not date | Does not match the specified date. |
| Column: Order Date Value: 31/12/2021 Example: Selects records where the Order Date column equals 31/12/2021 |
is today | Date field matches the current date. |
| Column: Deadline Date Example: Select records where the deadline date is today |
is before today | Date field is before the current date. |
| Column: Order Date Example: Select records where the Order Date before today |
is after today | Date field is after the current date. |
| Column: Exam Date Example: Select records where the Exam Date after today |
is within days | Date field is within a specified number of days from today. |
| Column: Invoice Date Value: 7 Example: Selects records where the Invoice Date column is within 7 days from today. |
is within weeks | Date field is within a specified number of weeks from today. |
| Column: Order Date Value: 2 Example: Selects records where the Order Date column is within the upcoming 2 weeks. |
is within months | Date field is within a specified number of months from today. |
| Column: Subscription Start Date Value: 3 Example: Selects records where the Subscription Start Date column is within the upcoming 3 months. |
is days ago | Date field is a specified number of days ago from today. |
| Column: Last Login Date Value: 7 Example: Selects records where the Last Login Date column is 7 days ago from today. |
is months ago | Date field is a specified number of months ago from today. |
| Column: Account Creation Date Value: 6 Example: Selects records where the Account Creation Date column is 6 months ago from today. |
is years ago | Date field is a specified number of years ago from today. |
| Column: Membership Renewal Date Value: 2 Example: Selects records where the Membership Renewal Date column is 2 years ago from today. |
in this week | Date field falls within the past week. |
| Column: Task Due Date Example: Selects records where the Task Due Date column falls within the current week from Sunday to Saturday. |
in this month | Date field falls within the current month. |
| Column: Payment Date Example: Selects records where the Payment Date column falls within the current month. |
in this year | Date field falls within the current year. |
| Column: Project Start Date Example: Selects records where the Project Start Date column falls within the current year. |
day of the month is | Day of the month matches the specified value. |
| Column: Appointment Date Value: 15 Example: Selects records where the Appointment Date column corresponds to the 15th day of the month. |
is before date | Date field is before the specified date. |
| Column: Event Start Date Value: "2024-06-01" Example: Selects records where the Event Start Date column is before June 1, 2024. |
is before or same date | Date field is before or the same as the specified date. |
| Column: Transaction Date Value: May 20, 2024 Example: Selects transactions that occurred on or before May 20, 2023. |
is after date | Date field is after the specified date. |
| Column: Transaction Date Value: May 20, 2023 Example: Selects transactions that occurred after May 20, 2023 |
is after or same date | Date field is after or the same as the specified date. |
| Column: Transaction Date Value: May 20, 2024 Example: Selects transactions that occurred on or after May 20, 2024. |
higher than | Number value is Numerically higher than the specified value. |
| Column: Sales Amount Value: 1000 Example: Selects records where the Sales Amount column is greater than 1000. |
lower than | Number value is Numerically lower than the specified value.
|
| Column: Discount Value: 0.1 Example: Selects records where the Discount column is less than 0.1. |