Filters Conditions | DataLexing

Condition	What it Does	Applies On	Example
is	Matches exactly the specified value.	Text, Number,Check Box	Column: Quantity. Value: 10. Example: Selects records where the Quantity column is exactly 10.
is not	Does not match the specified value.	Text, Number	Column: Price Value: 25.50 Example: Selects records where the Price column is not equal to 25.50.
contains	Contains the specified substring.	Text, Number, Date	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.	Text, Number, Date	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.	Text, Number	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.	Text	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.	Text	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.	All Types	Column: Comments Example: Selects records where the Comments column is empty.
is not empty	field is not empty	All Types	Column: Customer Name Example: Selects records where the Customer Name column is not empty.
is date	Matches exactly the specified date	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.	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.	Date	Column: Deadline Date Example: Select records where the deadline date is today
is before today	Date field is before the current date.	Date	Column: Order Date Example: Select records where the Order Date before today
is after today	Date field is after the current date.	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.	Date	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.	Date	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.	Date	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.	Date	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.	Date	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.	Date	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.	Date	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.	Date	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.	Date	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.	Date	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.	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.	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.	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.	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.	Number	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.	Number	Column: Discount Value: 0.1 Example: Selects records where the Discount column is less than 0.1.