# 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-09-27

Learn how to filter records in NocoDB.

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

Filters help you narrow down and organize data based on specific conditions. NocoDB supports:

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

Use filters to focus only on 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. Click the **Filter** button in the toolbar.
2. Choose **Add filter** or **Add filter group**.
3. Set up each filter by selecting a **Field**, **Operation**, and (if needed) a **Value**.
4. To refine results further, combine multiple filters using **AND** or **OR** logic.

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

### Group filters

You can group multiple filters together using a `Filter Group` to build complex, nested conditions. This allows you to combine filters using either `AND` or `OR` logic, enabling more precise control over your data. To create a filter group, click the `Filter` button in the toolbar and choose `+ Add filter group`. Within a group, you can add individual filters or even nest additional 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 on the trash / bin icon located to the right of the respective 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>

You can filter records based on the currently logged-in user using the **Current User** option when configuring filters on **User fields** and their derivatives (such as `createdBy` and `updatedBy`). This is especially useful for creating views that show only the records relevant to the user viewing 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 as an indicator.

<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 temporarily enable or disable individual filters without deleting them. This is useful when you want to quickly compare filtered and unfiltered views, or try different combinations of conditions without rebuilding them each time.

Each filter row includes a **checkbox** on the left side. Unchecking it disables the filter — the condition is preserved but no longer applied to the view. The toolbar badge shows a count in the format **enabled/total** (e.g., `2/5`) when some filters are disabled, so you always know how many are active.

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

Toggle filters work with both individual filters and filter groups. When a filter group is disabled, all filters within that group are also disabled. Disabled filters remain saved in the view and can be re-enabled 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 quick, one-click access to frequently used filters directly from the toolbar — without needing to open the filter menu. A pinned filter appears as a compact pill in the toolbar showing the field name and current value. Clicking the pill opens a dropdown where you can search and change the value instantly.

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

### Pin a filter

1. Click the **Filter** button in the toolbar and locate the filter you want to pin.
2. Click the **Pin** icon to the right of the filter row.
3. The filter appears as a pill in the toolbar, ready for quick access.

To unpin a filter, click the **Pin** icon again on the filter row — it will be highlighted for pinned filters.

### Using pinned filters

Clicking a pinned filter pill opens a dropdown panel directly in the toolbar. From here you can search for values, select or deselect options, and changes are applied to the view immediately. The dropdown also includes a **Clear value** option to reset the filter.

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

Each pill includes a **toggle icon** to quickly enable or disable the filter without opening the filter menu.

### Negated operators

When a pinned filter uses a negated operator (e.g., **is not**, **is not any of**), the pill displays a **diagonal strikethrough line** over the selected values. This visual cue makes it easy to distinguish between inclusive and exclusive filters at a glance.

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

### Supported field types

Pinned filters are supported for the following 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>

Only one filter per field can be pinned at a time — if a field already has a pinned filter, additional filters on the same field cannot be pinned. Filter groups cannot be pinned; only individual filters support pinning.

## Filters for editor role

Editors have full control over filters on views they can write to — **collaborative views** and their **own personal views**. They can add, edit, delete, toggle, and pin filters just like creators.

On views editors cannot write to — **locked views** and **other users' personal views** — the filter popup shows the view's saved filters as a single **read-only** list. The "+ Add filter" button and per-row edit, delete, toggle, and pin controls are hidden. If the view has no saved filters, a **"No filters applied"** empty state is shown.

In **publicly shared views**, filters and sorts applied from the toolbar are interactive but **not persisted** — they reset when the shared view is reopened.

## Enabling NULL and EMPTY filters

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

Before enabling the setting:

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

After enabling it, you’ll see additional options like `is null` and `is empty`, which let you filter out cells with `NULL` or empty values.

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

Alternatively, you can use **is blank** and **is not blank** filters to handle both NULL and EMPTY values in a simplified way.

## 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): Learn how to hide and reorder fields in NocoDB.
- [Sorting Records](https://nocodb.com/docs/product/tables/table-operations/sort.md): Learn how to sort records in NocoDB.
- [Grouping Records](https://nocodb.com/docs/product/tables/table-operations/group-by.md): Learn how to group records in NocoDB.
- [Colouring Records](https://nocodb.com/docs/product/tables/table-operations/record-colouring.md): Learn how to colour records and individual fields in NocoDB.
- [Record Height](https://nocodb.com/docs/product/tables/table-operations/row-height.md): Learn how to adjust the height of records in NocoDB.
- [Freeze Fields](https://nocodb.com/docs/product/tables/table-operations/freeze-fields.md): Keep up to three fields pinned in place while scrolling horizontally in Grid view.
- [Search](https://nocodb.com/docs/product/tables/table-operations/search.md): Learn how to search for records in NocoDB.
- [Realtime Presence](https://nocodb.com/docs/product/tables/table-operations/realtime-presence.md): See who else is working in a table, live, with per-collaborator markers in the grid.