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
  1. Text fields
  2. Number fields
  3. Date and time fields
  4. Choice fields
  5. Connection fields
  6. File and image fields
  7. Special cases
  8. Nested filter groups

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:

OperatorKeeps records where the field
contains / does not containHas (or lacks) the text anywhere in it
is / is notEquals (or does not equal) the value
is exactIs exactly the value
starts with / ends withBegins or ends with the text
is blank / is not blankIs 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:

OperatorKeeps records where the field
is / is notEquals (or does not equal) the number
higher than / higher than or equal toIs above the number, or above or equal to it
lower than / lower than or equal toIs below the number, or below or equal to it
is blank / is not blankHas 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:

OperatorValue you enter
is, is not, is before, is afterA date (and time on Date & Time)
is today, is today or before, is today or after, is before today, is after todayNone
is this week, is this month, is this quarter, is this year, and the same with is notNone
is last week, is last month, is last quarter, is last year, and the same with is notNone
is next week, is next month, is next quarter, is next year, and the same with is notNone
is during the currentweek, month, quarter or year
is during the previous, is during the next, is before the previous, is after the nextA number and days, weeks, months or years
is blank / is not blankNone
  • 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 typeOperators
Select, Radiois, is not, is blank, is not blank
Checkbox, Multi-Selectis, is not, contains, does not contain, is blank, is not blank
Decision Boxis 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:

OperatorWhen it is offeredKeeps records where
is logged in user / is not logged in userThe field connects to the Users tableThe connected user is (or is not) the person viewing the page
is connected to any logged in user's rolesThe field connects to the Users tableThe connected user shares a role with the person viewing the page
is connected to logged in user / is not connected to logged in userThe Users table also has a connection to the same table this field connects toThe 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 typeOperators
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.

Was this page helpful?

Something wrong or missing on this page? Tell us.