# Filter conditions for each field type

> Every operator a data source filter offers for text, number, date, choice, connection and file fields, plus how blanks, record IDs and equations filter.

Source: https://tadabase.com/docs/pages/data-source-filtering  
Status: Verified Nov 17, 2026. Checked against the current product

This page lists the operators you can pick in a data component's data source filters, by field type, with the exact labels the builder shows. For how to add filters, groups, sorting and limits, see [Filter, sort and limit the records a component shows](https://tadabase.com/docs/pages/data-source).

Display rules use the same condition builder with a shorter list: no **is exact** and no logged-in user operators.

## Text fields

For **Text**, **Long Text**, **Rich Text**, **Person Name**, **Email**, **Address** and **Phone Number** fields, and **Equation** fields that return text:

| Operator | Keeps records where the field |
| --- | --- |
| **contains** / **does not contain** | Has (or lacks) the text anywhere in it |
| **is** / **is not** | Equals (or does not equal) the value |
| **is exact** | Is exactly the value |
| **starts with** / **ends with** | Begins or ends with the text |
| **is blank** / **is not blank** | Is empty, or has any value |

**Text Formula**, **Link**, **Date Formula** and other field types not listed on this page offer **is**, **is not**, **is blank** and **is not blank**.

## Number fields

For **Number**, **Currency**, **Basic Formula**, **Rollup** and **Rating** fields, **Equation** fields that return a number, and the built-in **Auto Increment** field:

| Operator | Keeps records where the field |
| --- | --- |
| **is** / **is not** | Equals (or does not equal) the number |
| **higher than** / **higher than or equal to** | Is above the number, or above or equal to it |
| **lower than** / **lower than or equal to** | Is below the number, or below or equal to it |
| **is blank** / **is not blank** | Has no number, or has one |

**Slider** fields have the same list without **is not blank**. To keep a range, put two conditions in a **Match All** group, for example **Amount** **higher than or equal to** `100` and **Amount** **lower than** `500`.

## Date and time fields

**Date** and **Date & Time** fields, **Equation** fields that return a date, the start or end of a **Date Range** field, and the built-in **Created At** field offer:

| Operator | Value you enter |
| --- | --- |
| **is**, **is not**, **is before**, **is after** | A date (and time on Date & Time) |
| **is today**, **is today or before**, **is today or after**, **is before today**, **is after today** | None |
| **is this week**, **is this month**, **is this quarter**, **is this year**, and the same with **is not** | None |
| **is last week**, **is last month**, **is last quarter**, **is last year**, and the same with **is not** | None |
| **is next week**, **is next month**, **is next quarter**, **is next year**, and the same with **is not** | None |
| **is during the current** | **week**, **month**, **quarter** or **year** |
| **is during the previous**, **is during the next**, **is before the previous**, **is after the next** | A number and **days**, **weeks**, **months** or **years** |
| **is blank** / **is not blank** | None |

- **is not today** is offered on **Date** fields only.
- **is before current time** and **is after current time** are offered on **Date & Time** fields, not on **Date** fields or a **Date Range** start or end.
- A **Date Range** field itself (not its start or end) offers only **is blank** and **is not blank**.

**Time** fields offer **is**, **is not**, **is before**, **is after**, **is before current time**, **is after current time**, **is blank** and **is not blank**.

When a top-level filter group has a condition on a **Date** or **Date & Time** field, a question-mark button (**Preview Date Filters**) appears in the group's header. Use it to check which dates a relative operator such as **is during the previous** covers.

## Choice fields

| Field type | Operators |
| --- | --- |
| **Select**, **Radio** | **is**, **is not**, **is blank**, **is not blank** |
| **Checkbox**, **Multi-Select** | **is**, **is not**, **contains**, **does not contain**, **is blank**, **is not blank** |
| **Decision Box** | **is checked**, **is unchecked** |

For **is** and **is not** you pick the value from the field's options. To keep records with one of several options, add one condition per option in a **Match Any** group.

## Connection fields

Every connection field offers **is**, **is not**, **is blank** and **is not blank**. For **is** and **is not** you pick one or more connected records. Some connections offer more operators that compare with the logged-in user:

| Operator | When it is offered | Keeps records where |
| --- | --- | --- |
| **is logged in user** / **is not logged in user** | The field connects to the Users table | The connected user is (or is not) the person viewing the page |
| **is connected to any logged in user's roles** | The field connects to the Users table | The connected user shares a role with the person viewing the page |
| **is connected to logged in user** / **is not connected to logged in user** | The Users table also has a connection to the same table this field connects to | The connected record is (or is not) the one connected to the logged-in user. You choose which Users connection field to compare with. |

Example: jobs connect to a company, and each user connects to a company. To show each user only their company's jobs, filter **Company** **is connected to logged in user** and choose the Users table's company field.

You can also filter on the fields of a connected table: they are listed in the field menu under the name of the connection.

## File and image fields

| Field type | Operators |
| --- | --- |
| **Attachments** (and older **File** fields) | **is blank**, **is not blank**, **size is less than**, **size is greater than**, **file type is**, **file type is not** |
| **Signature** (and older **Image** fields) | **is blank**, **is not blank** |

The size operators take a number and a unit: **bytes**, **kilobytes** or **megabytes**.

## Special cases

- **Blank is not zero.** On **Number**, **Currency** and **Rating** fields, **is blank** keeps only records with no value. A field that holds `0` is not blank; to find zeros, use **is** `0`.
- **Record ID.** The built-in **Record ID** field offers **is** and **is not**.
- **Auto Increment.** The built-in **Auto Increment** field filters like a number, so you can use **higher than** and **lower than** to keep a range of record numbers.
- **Equations.** An **Equation** field filters by its result type: text operators for text, number operators for numbers, date operators for dates.
- **Formulas.** **Basic Formula** and **Rollup** fields use the number operators. **Text Formula** and **Date Formula** fields offer only **is**, **is not**, **is blank** and **is not blank**.

## Nested filter groups

A data source can have several filter groups, and each group can hold child groups (**Add Child Filter Group**).

- Separate filter groups must all match.
- Inside a group, **Match All** needs every condition and **Match Any** needs one.
- A child group is one more condition of its parent. It is combined with the parent's other conditions by the parent's **Match All** or **Match Any** setting, not always with AND.

Example: to show tickets that are urgent, or high priority and older than two days, set the parent group to **Match Any** with **Priority** **is** `Urgent`, then add a child group set to **Match All** with **Priority** **is** `High` and **Created At** **is before the previous** `2` **days**.
