Overview
The Filters Panel offers a broad selection of operators, enabling you to apply conditions like exact matches, exclusions, and partial text matches to quickly identify the most relevant items. This page provides a detailed overview of the supported operators for each field type.
Text Fields
The table below outlines the supported filter operators for the following field types:
Text
Text Concatenation (searchable)
Text Box
Rich Text
Email
URL
File Info
XMP/IPTC Data
Automatic Numbering
# | Operator | Value | Example | Peculiarities |
|---|---|---|---|---|
1 | IS EQUAL | typed value | Campaign Name - IS EQUAL - Spring | Text case is ignored; File Info Size must include only the exact value (35384 instead of 35 KB); |
2 | IS NOT EQUAL | typed value | Campaign Name - IS NOT EQUAL - Spring | |
3 | CONTAINS | typed value | Campaign Name - CONTAINS - spr Results: xxxSPRxx | Text case is ignored; |
4 | DOES NOT CONTAIN | typed value | Campaign Name - DOES NOT CONTAIN - spr | Text case is ignored; |
5 | IS EMPTY | Campaign Name - IS EMPTY | ||
6 | IS NOT EMPTY | Campaign Name - IS NOT EMPTY | ||
Numeric Fields
The table below outlines the supported filter operators for the following field types:
Integer
Decimal Numeral
Percentage
Ref. Number
# | Operators | Value | Example |
|---|---|---|---|
1 | IS EQUAL | typed number | Campaign number - IS EQUAL - 8 |
2 | IS NOT EQUAL | typed number | Campaign number - IS NOT EQUAL - 8 |
3 | GREATER THAN | typed number | Campaign number - GREATER THAN - 8 |
4 | GREATER OR EQUAL TO | typed number | Campaign number - GREATER OR EQUAL TO - 8 |
5 | LESS THAN | typed number | Campaign number - LESS THAN - 8 |
6 | LESS THAN OR EQUAL TO | typed number | Campaign number - LESS THAN OR EQUAL TO - 8 |
Selection Fields
The table below outlines the supported filter operators for the following field types:
Radio Buttons
Status Field
Select Box
Checkboxes
Multi-Select
# | Operators | Value | Example | Peculiarities |
|---|---|---|---|---|
1 | IS ANY OF | selection of value(s) from list | Campaign Type - IS ANY OF - Leaflet OR TV banner OR Newsletter | |
2 | IS NONE OF | selection of value(s) from list | Campaign Type - IS NONE OF - Leaflet OR TV banner OR Newsletter | |
3 | IS EQUAL | selection of value from list | Campaign Type - IS EQUAL - Leaflet | |
4 | IS NOT EQUAL | selection of value from list | Campaign Type - IS NOT EQUAL - Leaflet | This filter applied to single select fields doesn't return items with empty field - Fixed in v16 |
5 | IS EMPTY | Campaign Type IS EMPTY | ||
6 | IS NOT EMPTY | Campaign Type IS NOT EMPTY | ||
Duration Fields
The table below outlines the supported filter operators for the following field types:
Duration Field
# | Operators | Value | Example | Peculiarities |
|---|---|---|---|---|
1 | IS EQUAL | typed number | Duration - IS EQUAL - 2w 5d 8h | |
2 | IS NOT EQUAL | typed number | Duration - IS NOT EQUAL - 2w 5d 8h |
Date Fields
The table below outlines the supported filter operators for the following field types:
Date Field
# | Operators | Value | Example | Peculiarities |
|---|---|---|---|---|
1 | IS | exact date | Start date - IS - 17 Oct 2022 | User cannot insert date in the field from keyboard |
TODAY YESTERDAY TOMORROW THIS WEEK LAST WEEK NEXT WEEK THIS MONTH NEXT MONTH THIS MONTH | Start date - IS - TODAY | |||
2 | IS NOT | exact date | Start date - IS NOT - 17 Oct 2022 | User cannot insert date in the field from keyboard; This filter doesn't return items with empty field |
TODAY YESTERDAY TOMORROW THIS WEEK LAST WEEK NEXT WEEK THIS MONTH NEXT MONTH THIS MONTH | Start date - IS NOT - TODAY | This filter doesn't return items with empty field | ||
3 | IS IN THE LAST | number, unit (DAYS, WEEKS, MONTHS) | Start date - IS IN THE LAST - 10 - days | |
4 | IS IN THE NEXT | number, unit (DAYS, WEEKS, MONTHS) | Start date - IS IN THE NEXT - 10 - days | |
5 | IS BETWEEN | exact dates | Start date - IS BETWEEN - 10 Oct 2022 - 17 Oct 2022 | The first selected date/week/month must be prior to the second selected date/week/month *Comparing time values within the same date, user can insert second time lower then in first field but it will not work |
6 | IS ON OR AFTER | exact date | Start date - IS ON OR AFTER - 17 Oct 2022 | User cannot insert date in the field from keyboard |
TODAY YESTERDAY TOMORROW THIS WEEK LAST WEEK NEXT WEEK THIS MONTH NEXT MONTH THIS MONTH | Start date - IS ON OR AFTER - THIS MONTH | |||
7 | IS AFTER | exact date | Start date - IS AFTER - 17 Oct 2022 | User cannot insert date in the field from keyboard |
TODAY YESTERDAY TOMORROW THIS WEEK LAST WEEK NEXT WEEK THIS MONTH NEXT MONTH THIS MONTH | Start date - IS AFTER - THIS MONTH | |||
8 | IS ON OR BEFORE | exact date | Start date - IS ON OR BEFORE - 17 Oct 2022 | User cannot insert date in the field from keyboard |
TODAY YESTERDAY TOMORROW THIS WEEK LAST WEEK NEXT WEEK THIS MONTH NEXT MONTH THIS MONTH | Start date - IS ON OR BEFORE - THIS MONTH | |||
9 | IS BEFORE | exact date | Start date - IS BEFORE - 17 Oct 2022 | User cannot insert date in the field from keyboard |
TODAY YESTERDAY TOMORROW THIS WEEK LAST WEEK NEXT WEEK THIS MONTH NEXT MONTH THIS MONTH | Start date - IS BEFORE - THIS MONTH | |||
10 | IS EMPTY | Start date - IS EMPTY | ||
11 | IS NOT EMPTY | Start date - IS NOT EMPTY | ||