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.
- Verified Nov 17, 2026
- Classic builder
On this page
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.
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
0is not blank; to find zeros, use is0. - 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.
Was this page helpful?
Something wrong or missing on this page? Tell us.