--- title: "Supported Filter Operators" slug: "supported-filter-operators" updated: 2025-06-11T20:12:37Z published: 2025-06-11T20:12:37Z --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.encodify.com/llms.txt > Use this file to discover all available pages before exploring further. # Supported Filter Operators ## 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: **SPR**ing xxx**SPR**xx | 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 | |