# Filtering Records

> Part of the NocoDB documentation (Product docs > Tables > Table Operations > Work with Data). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/product/tables/table-operations/filter
Last updated: 2026-10-03

Filter records in a NocoDB view with conditions, filter groups, toggle filters and pinned filters.

<img alt="Filter" src={__img0} placeholder="blur" />

Filters show only the records that match specific conditions. NocoDB supports:

* **Nested filters**: Combine multiple conditions across different fields.
* **AND / OR logic**: Choose how filters are grouped.

Use filters to see only the records that matter to you.

<AskNocoAI>
  <Prompt>
    Show only records assigned to me
  </Prompt>

  <Prompt>
    Show only records where [Status] is not [Done] and [Due Date] is this week
  </Prompt>

  <Prompt>
    Hide records created before [1 January 2026]
  </Prompt>

  <Prompt>
    Remove all filters from this view
  </Prompt>
</AskNocoAI>

## Add or edit filters

1. In the toolbar, click **Filter**.
2. Select **Add filter** or **Add filter group**.
3. For each filter, select a **Field** and an **Operation**. If the operation needs a **Value**, enter it.
4. To refine the results more, combine filters with **AND** or **OR** logic.

<img alt="Add Filter" src={__img1} placeholder="blur" />

### Group filters

Use a `Filter Group` to put filters together and build complex, nested conditions. In a group, you combine the filters with `AND` or `OR` logic. This gives you more precise control over your data.

To create a filter group:

1. In the toolbar, click `Filter`.
2. Select `+ Add filter group`.

In a group, you can add individual filters or nest more groups.

<img alt="Grouped Filters" src={__img2} placeholder="blur" />

## Delete filters

<Callout type="info">
  NocoDB supports upto 5 levels of nested filter groups.
</Callout>

To remove a filter, click the trash / bin icon to the right of the filter.

<img alt="Delete Filter" src={__img3} placeholder="blur" />

## Filter by current user ☁

<Callout type="info">
  This feature is available on 

  **NocoDB Cloud**

   (Business plan and above) and licensed self-hosted deployments (Business plan and above).
</Callout>

Use the **Current User** option to filter records by the user who is logged in. This option is available for filters on **User fields** and fields derived from them (for example, `createdBy` and `updatedBy`). Use it to create views that show only the records relevant to the user who views them.

<img alt="Filter by Current User" src={__img4} placeholder="blur" />

When a dynamic **Current User** filter is applied, the toolbar shows an **@** icon next to the filter count.

<img alt="Filter by Current User" src={__img5} placeholder="blur" />

<Callout type="warning">
  **Current User**

   filters do not apply in publicly shared views. If no other filters are present, the shared view will display no records.
</Callout>

## Toggle filters ☁

<Callout type="info">
  This feature is available on 

  **NocoDB Cloud**

   (Plus plan and above) and licensed self-hosted deployments (Business plan and above).
</Callout>

Toggle filters let you turn individual filters off and on for a time without deleting them. Use them to compare filtered and unfiltered views quickly. You can also try different combinations of conditions without building them again each time.

Each filter row has a **checkbox** on the left side. Clear the checkbox to disable the filter. NocoDB keeps the condition but does not apply it to the view.

When some filters are disabled, the toolbar badge shows the count as **enabled/total** (for example, `2/5`). You always know how many filters are active.

<img alt="Toggle Filters" src={__img6} placeholder="blur" />

Toggle filters work with individual filters and with filter groups. When you disable a filter group, all filters in that group are also disabled. Disabled filters stay saved in the view. You can enable them again at any time.

## Pinned filters ☁

<Callout type="info">
  This feature is available on 

  **NocoDB Cloud**

   (Plus plan and above) and licensed self-hosted deployments (Business plan and above).
</Callout>

Pinned filters give you one-click access to filters that you use frequently, directly from the toolbar. You do not have to open the filter menu. A pinned filter shows as a compact pill in the toolbar, with the field name and the current value. Click the pill to open a dropdown. In the dropdown, search for a value and change it immediately.

<img alt="Pinned Filters" src={__img7} placeholder="blur" />

### Pin a filter

1. In the toolbar, click **Filter**.
2. Find the filter to pin.
3. Click the **Pin** icon to the right of the filter row. The filter shows as a pill in the toolbar.

To unpin a filter, click the **Pin** icon on the filter row again. The icon is highlighted for pinned filters.

### Using pinned filters

Click a pinned filter pill to open a dropdown panel in the toolbar. In the panel, you can:

* search for values
* select or clear options; NocoDB applies the changes to the view immediately
* click **Clear value** to reset the filter

<img alt="Pinned Filter Actions" src={__img8} placeholder="blur" />

Each pill has a **toggle icon**. Click it to enable or disable the filter without opening the filter menu.

### Negated operators

When a pinned filter uses a negated operator (for example, **is not** or **is not any of**), the pill shows a **diagonal strikethrough line** over the selected values. This line helps you see at a glance which filters include values and which filters exclude them.

<img alt="Pinned Filter Negated" src={__img9} placeholder="blur" />

### Supported field types

You can pin filters on these field types:

* **Single Select**
* **Multi Select**
* **User**
* **Created By**
* **Last Modified By**

### Limitations

<Callout type="info">
  You can pin up to 

  **3 filters**

   per view.
</Callout>

* You can pin only one filter for each field. If a field already has a pinned filter, you cannot pin other filters on the same field.
* You cannot pin filter groups. You can pin only individual filters.

## Filters for editor role

Editors have full control over filters on views that they can write to: **collaborative views** and their **own personal views**. Like creators, they can add, edit, delete, toggle and pin filters.

Some views editors cannot write to: **locked views** and **other users' personal views**. On these views, the filter popup shows the saved filters of the view as one **read-only** list. The "+ Add filter" button is hidden. The edit, delete, toggle and pin controls on each row are also hidden. If the view has no saved filters, the popup shows the empty state **"No filters applied"**.

In **publicly shared views**, you can use the filters and sorts in the toolbar, but they are **not persisted**. They reset when you open the shared view again.

## Enabling NULL and EMPTY filters

By default, the filter menu hides the filters `is null`, `is not null`, `is empty` and `is not empty`. To use them, go to [Data display](/docs/product/bases/actions-on-base#data-display) and enable **Show NULL and EMPTY in Filter**.

Before you enable the setting:

<img alt="Show isBlank" src={__img10} placeholder="blur" />

After you enable it, the menu shows more options, for example `is null` and `is empty`. Use them to filter out cells with `NULL` or empty values.

<img alt="Show NULL and EMPTY Filter" src={__img11} placeholder="blur" />

You can also use the **is blank** and **is not blank** filters. They handle both NULL and EMPTY values in one filter.

## Related

* [Filter records using AI](/docs/product/noco-ai/create-filter): describe the records you want and NocoAI sets up the filters

---

## Related pages

- [Hide & Reorder Fields](https://nocodb.com/docs/product/tables/table-operations/field-operations.md): Hide, show and reorder fields in a NocoDB view from the Fields menu in the toolbar.
- [Sorting Records](https://nocodb.com/docs/product/tables/table-operations/sort.md): Sort records in a NocoDB view by one or more fields, in ascending or descending order.
- [Grouping Records](https://nocodb.com/docs/product/tables/table-operations/group-by.md): Group records in a NocoDB view by up to three levels of fields, with group aggregations.
- [Colouring Records](https://nocodb.com/docs/product/tables/table-operations/record-colouring.md): Color records and individual fields in NocoDB views, based on a single select field or on conditions.
- [Record Height](https://nocodb.com/docs/product/tables/table-operations/row-height.md): Set the record height in a NocoDB grid to Short, Medium, Tall or Extra.
- [Freeze Fields](https://nocodb.com/docs/product/tables/table-operations/freeze-fields.md): Freeze up to three fields in a NocoDB Grid view so they stay in place when you scroll horizontally.
- [Search](https://nocodb.com/docs/product/tables/table-operations/search.md): Search for records in a NocoDB table, in one field or in all fields, from the toolbar.
- [Realtime Presence](https://nocodb.com/docs/product/tables/table-operations/realtime-presence.md): See live in NocoDB who else works in a table, with a color marker for each collaborator in the grid.