Help Center Records, views & tasksLook it up

Filter records: every operator for each field type

Build a filter from conditions that are all joined with “and”, or all with “or”. Each field type has its own operators, and some fields take several values in one condition.

7 minUpdated Oct 27, 2026

Open in Corteksa

Steps

Open the view, choose Filter, then press Add condition.

Choose the field, then the operator, then the value or values.

The changes apply as you edit.

Add more conditions. On the second condition, press And to switch it to Or: all the conditions are joined the same way, And (all of them) or Or (any of them).

Save the view, or save the filter on its own. See Save a filter to reuse or share.

Relative dates

Only three are available: “Today”, “This week” and “This month”. They’re calculated in your time zone, and the week starts on the day the workspace owner chose. See The workspace time zone and start of the week.

Several values in one condition

For status, multi-select, tags and lead form fields, you can choose several values in one condition. “Is any of” and “Contains” match any of the chosen values, and “Does not contain” excludes all of them.

An empty list cancels the condition; it doesn’t mean “nothing”.

The assignee filter

Option

What it means

The person who opens the view

All assignees

All records

Specific people

Records where one of them is an assignee

Unassigned

Records with no assignee

In the filter builder, the “Owner” field matches the primary assignee only, and “Owner’s group” matches the records whose primary assignee is in one of the chosen teams.

A filter narrows what you see, and never widens it beyond your permissions.

At a glance

The operators in Filter for each field type:

Field type

Operators

Text

Contains, Does not contain, Equals, Does not equal, Starts with, Ends with, Is empty, Is not empty

Long text

Contains, Does not contain, Is empty, Is not empty

Contains, Equals, Does not equal, Starts with, Ends with, Is empty, Is not empty

Link, phone, WhatsApp

Contains, Equals, Starts with, Ends with, Is empty, Is not empty

Number, currency, calculation

Equals, Does not equal, Greater than, Less than, Greater than or equal, Less than or equal, Between, Is empty, Is not empty

Rating

Equals, Does not equal, Greater than, Less than, Greater than or equal, Less than or equal

True/False

Equals, Is empty, Is not empty

Date, date and time, start date, due date

Equals, Before, After, Between dates, Today, This week, This month, Is empty, Is not empty

Select, priority

Equals, Does not equal, Contains, Does not contain, Is empty, Is not empty

Status

Is any of, Is empty, Is not empty

Multi-select, tags, lead form

Contains, Does not contain, Is empty, Is not empty

Source and ad fields

Equals, Is empty, Is not empty

Session name, provider ID

Equals, Is empty, Is not empty

Relation

Equals, Is empty, Is not empty

File, image, rollup

Is empty, Is not empty

Location

Contains, Does not contain, Equals, Starts with, Ends with, Is empty, Is not empty

Serial number

Contains, Equals, Starts with, Ends with, Is empty, Is not empty

Lookup

The operators of the original field’s type

Created At and Updated At

The date operators

Created By, Updated By, Belongs To

Equals, Does not equal, Is empty, Is not empty

The filter button in a table column’s header can offer more operators for some fields, such as “Is any of” on text and choice fields.

If something goes wrong

What you see

Why

What to do

“The filter has more values than allowed”

More than 100 values in a negative operator.

Split the condition, or use a positive operator.

The view shows records that didn’t show before

An old view with a list value now matches any value in the list.

Review the condition and change it.

A condition disappeared from the view

The field it used was deleted.

Add the condition again with another field.

A real example

Shield Security Co.

The situation

The manager wants the contracts in Riyadh that end this month and haven’t been renewed.

What they did

Conditions: End date This month and Status Is any of “Active, Awaiting renewal”.
And City Equals Riyadh.

The result

An accurate renewals list that the team follows up every morning.

A made-up company, to show the idea. The numbers are rounded.

Good to know

You can’t mix “and” and “or” in one filter: all the conditions are joined the same way.

Up to 50 conditions.

A condition’s value is up to 512 characters.

Up to 100 values in one condition. In negative operators, the condition is refused if it goes over.

The list of values in a column filter shows up to 200 values from what you can see.

There are no options such as “Yesterday” or “Last 7 days”. Use “Between dates”.

Did this guide solve it?

If not, we’ll ask what was missing.

Next, you might need