# Filter Records Using AI

> Part of the NocoDB documentation (Product docs > NocoAI). 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/noco-ai/create-filter
Last updated: 2026-10-03

Filter NocoDB table records with a plain-language description through NocoAI.

## Overview

With **NocoAI**, you describe the data that you want to see in plain English. NocoAI then applies the correct filter conditions. You do not set filter operators, values and conditions manually. Type a description such as *"Show high priority tasks due this week"*, and NocoAI sets up the filters for you.

Use it to narrow down records quickly and to explore data without filter syntax. Non-technical users can also build complex filter conditions with it.

## Steps to Filter Records Using AI

1. In the toolbar above your table, click **Filter**. The filter panel opens.

2. At the top of the filter panel, find the AI text input with the ✨ icon.

3. Type a plain-language description of the records that you want to see.

   *Example*:

   > Show high priority tasks that are due this week

4. Press **Enter** or click **Send**. NocoAI analyzes the structure of your table and generates the filter conditions.

   The generated filters appear in the filter panel. NocoAI applies them to your view immediately. You do not need to confirm them.

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

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

## Supported Actions

NocoAI finds your intent and does one of three filter actions:

| Action      | When it's used                                      | Example prompt                            |
| ----------- | --------------------------------------------------- | ----------------------------------------- |
| **Add**     | Adds new filters to the existing filters            | "Also show rows where Status is Done"     |
| **Replace** | Removes all current filters and applies new filters | "Show only rows where Score is above 80"  |
| **Clear**   | Removes all existing filters                        | "Remove all filters" or "Show everything" |

## Supported Filter Types

NocoAI generates filters for many field types:

| Field Type                                      | Example Prompts                                               |
| ----------------------------------------------- | ------------------------------------------------------------- |
| **Text** (SingleLineText, Email, URL)           | "Title contains meeting", "Title is either A or B"            |
| **Number** (Number, Decimal, Currency, Percent) | "Price is greater than 100", "Score between 50 and 80"        |
| **SingleSelect / MultiSelect**                  | "Status is either Todo or In progress", "Tags include urgent" |
| **Date / DateTime**                             | "Due this week", "Created after 2025-01-01", "Modified today" |
| **Checkbox**                                    | "Show only checked items", "Where completed is unchecked"     |
| **Rating**                                      | "Rating is 4 or above"                                        |

NocoAI also knows the difference between **AND** and **OR** logic:

* "Priority is High and Status is not Done" → AND conditions
* "Title is either Alpha or Beta" → OR conditions

## Tips for Better AI Filters

* **Use exact field names when possible**

  NocoAI compares your words with the column names of your table. Exact names give more accurate results.
  *Example*: If your column name is "Due Date", say *"Due Date is this week"*, not *"due soon"*.

* **Be specific about values**

  For select fields, use the exact option values.
  *Example*: *"Status is In progress"* works better than *"status is active"* if your options are `Todo`, `In progress`, `Done`.

* **Use keywords for clear/replace**

  To remove filters, say *"clear filters"*, *"remove all filters"*, *"show everything"*, or *"reset"*.
  To replace all existing filters, start with *"show only ..."* or *"instead show ..."*.

* **Start simple, then refine**

  You can add filters one at a time. Start with *"Status is Todo"*. Then add *"also where Priority is High"*.

* **Match filter type with field type**

  Make sure that your condition fits the field type. For example, the filter *"Price \< 50"* does not work if the Price field is a text field. Number comparisons work only on number fields.

## Example Prompts and Outcomes

| Prompt                            | Generated Filters                                 |
| --------------------------------- | ------------------------------------------------- |
| "Show high priority tasks"        | Priority `is equal` High                          |
| "Title is either Alpha or Beta"   | Title `is equal` Alpha `OR` Title `is equal` Beta |
| "Status is Todo or In progress"   | Status `is any of` Todo, In progress              |
| "Due this week"                   | Due Date `is within` next week                    |
| "Items with no status"            | Status `is blank`                                 |
| "Remove all filters"              | All existing filters cleared                      |
| "Show only rows where Score > 80" | Existing filters replaced with Score `>` 80       |

## What's Next

After you filter records with AI, try more NocoAI capabilities:

* Create **[Views using AI](/docs/product/noco-ai/create-view)** to set up useful views for your data
* Create **[Fields using AI](/docs/product/noco-ai/create-field)** to generate relevant columns automatically
* Generate **[Formulas using AI](/docs/product/noco-ai/create-formula)** to automate calculations

Let NocoAI make the filter logic, and focus on your data.

## Availability

* AI filters are available on **NocoDB Cloud** (Plus plan and above). On Cloud, they use [credits](/docs/product/workspaces/credits).
* On self-hosted deployments (Business plan and above), you must configure your own AI integration to use AI.

---

## Related pages

- [What NocoAI can do](https://nocodb.com/docs/product/noco-ai/capabilities.md): The full list of actions that the NocoAI assistant can do in NocoDB, the role each action needs, and what NocoAI cannot do yet.
- [Create Base Using AI](https://nocodb.com/docs/product/noco-ai/create-base.md): Generate a complete NocoDB base with tables, views, fields and relationships from a plain-language prompt with NocoAI.
- [Create Tables Using AI](https://nocodb.com/docs/product/noco-ai/create-table.md): Generate NocoDB tables and their relationships from plain-language prompts with NocoAI.
- [Create Views Using AI](https://nocodb.com/docs/product/noco-ai/create-view.md): Generate useful views for a NocoDB table with NocoAI.
- [Create Fields Using AI](https://nocodb.com/docs/product/noco-ai/create-field.md): Generate relevant fields for a NocoDB table from a description with NocoAI.
- [Create Options Using AI](https://nocodb.com/docs/product/noco-ai/create-options.md): Generate options for NocoDB Single Select and Multi Select fields with NocoAI.
- [Generate Formulas Using AI](https://nocodb.com/docs/product/noco-ai/create-formula.md): Generate NocoDB formulas from plain-language prompts with NocoAI.