Filtering methods
Choose Flexim filtering methods for each field type, including text, numbers, dates, relations, and boolean values.
Each field type has its own set of filtering methods that help you find the data you need inside a collection. First, let's look at all available filtering methods, and then go through each field type.
All methods
| Filtering method | Meaning | Used by |
|---|---|---|
| Is, Is not | Exact match or complete mismatch with the entered value | Text, Rich Text, Auto Generate (slug), E-mail |
| Contain, Doesn't Contain | Partial match or partial mismatch with the entered value | Text, Rich Text, Auto Generate (slug), Select, Relation, E-mail |
| Is Empty, Is Not Empty | Check for an empty or filled field | Text, Rich Text, Number, Media, Select, Relation, Auto Generate (slug), E-mail |
| True, False | Check for the value True or False | Boolean, Auto Generate (condition) |
| =, ≠ | Match or mismatch of numeric values | Number |
| <, > | Check for a lower or higher numeric value | Number |
| ≤, ≥ | Check for a lower-or-equal, higher-or-equal numeric value | Number |
Methods for specific fields
Let's look at which filtering methods are available for each field type.
Text
| Filtering method | Meaning | Note |
|---|---|---|
| Is, Is not | Exact match or complete mismatch with the entered value | |
| Contain, Doesn't Contain | Partial match or partial mismatch with the entered value | |
| Is Empty, Is Not Empty | Check for an empty or filled field |
Rich Text
| Filtering method | Meaning | Note |
|---|---|---|
| Is, Is not | Exact match or complete mismatch with the entered value | |
| Contain, Doesn't Contain | Partial match or partial mismatch with the entered value | |
| Is Empty, Is Not Empty | Check for an empty or filled field |
Number
| Filtering method | Meaning | Note |
|---|---|---|
| =, ≠ | Match or mismatch of numeric values | |
| <, > | Check for a lower or higher numeric value | |
| ≤, ≥ | Check for a lower-or-equal, higher-or-equal numeric value | |
| Is Empty, Is Not Empty | Check for an empty or filled field |
Boolean
| Filtering method | Meaning | Note |
|---|---|---|
| True, False | Check for the value True or False |
Media
| Filtering method | Meaning | Note |
|---|---|---|
| Is Empty, Is Not Empty | Check for an empty or filled field |
Relation
| Filtering method | Meaning | Note |
|---|---|---|
| Contain, Doesn't Contain | Match or mismatch with the record selected in the dropdown | |
| Is Empty, Is Not Empty | Check for an empty or filled field |
AG-slug
| Filtering method | Meaning | Note |
|---|---|---|
| Is, Is not | Exact match or complete mismatch with the entered value | |
| Contain, Doesn't Contain | Partial match or partial mismatch with the entered value | |
| Is Empty, Is Not Empty | Check for an empty or filled field |
AG-boolean
| Filtering method | Meaning | Note |
|---|---|---|
| True, False | Check for the value True or False |
Select
| Filtering method | Meaning | Note |
|---|---|---|
| Contain, Doesn't Contain | Match or mismatch with the option selected in the dropdown | For multi-select fields you can pick several options |
| Is Empty, Is Not Empty | Check for an empty or filled field |
| Filtering method | Meaning | Note |
|---|---|---|
| Is, Is not | Exact match or complete mismatch with the entered value | |
| Contain, Doesn't Contain | Partial match or partial mismatch with the entered value | |
| Is Empty, Is Not Empty | Check for an empty or filled field |
Fields that cannot be filtered
- JSON
- Component
- Password
- Array
- Date
Read more on this topic