> ## Documentation Index
> Fetch the complete documentation index at: https://docs.airscale.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Filter tables

> Apply filters to your tables to quickly find and analyze the data that matters most

## 1. Click on "Filter"

<img src="https://mintcdn.com/airscale/aXid-NqBkne9U7iH/images/docs/blJsmmgUvW11k4Fs6cLyHca9N8.png?fit=max&auto=format&n=aXid-NqBkne9U7iH&q=85&s=ce38ac2a93df247caa7d18cb36ed721f" alt="Filter tables — 1. Click on &#x22;Filter&#x22;" width="1962" height="1448" data-path="images/docs/blJsmmgUvW11k4Fs6cLyHca9N8.png" />

You will then have the option to select one or several columns from your table:

<img src="https://mintcdn.com/airscale/k5o-AmvNyj_yzMcY/images/docs/jgITzqvLJ7GmV1ycXslEeF8Nc.png?fit=max&auto=format&n=k5o-AmvNyj_yzMcY&q=85&s=f71150e24f087aed71362e6708af36ba" alt="Filter tables — 1. Click on &#x22;Filter&#x22;" width="2276" height="1446" data-path="images/docs/jgITzqvLJ7GmV1ycXslEeF8Nc.png" />

Once a column is selected, you will have several filtering options available (depending on whether it’s a text field, a numeric field, or an email field):<br />

***Example of filtering emails:***

<img src="https://mintcdn.com/airscale/k5o-AmvNyj_yzMcY/images/docs/qU01hb2GBvxtzGyvM9bYDVIKKdU.png?fit=max&auto=format&n=k5o-AmvNyj_yzMcY&q=85&s=246403000b44a9cea3155c0ba9fb736a" alt="Filter tables — 1. Click on &#x22;Filter&#x22;" width="1546" height="676" data-path="images/docs/qU01hb2GBvxtzGyvM9bYDVIKKdU.png" />

***Example of filtering text field :***

<img src="https://mintcdn.com/airscale/k5o-AmvNyj_yzMcY/images/docs/yJzejorzXa4cpvUdfRd8jhyVE.png?fit=max&auto=format&n=k5o-AmvNyj_yzMcY&q=85&s=e095f81d198b6dbf920d1492742545f0" alt="Filter tables — 1. Click on &#x22;Filter&#x22;" width="1634" height="714" data-path="images/docs/yJzejorzXa4cpvUdfRd8jhyVE.png" />

***Example of filtering a numeric field :***

<img src="https://mintcdn.com/airscale/k5o-AmvNyj_yzMcY/images/docs/uweckD9tRl88SZWrNHj5WFA2GXA.png?fit=max&auto=format&n=k5o-AmvNyj_yzMcY&q=85&s=41b0e205666394d36f241dcfe6d2c00e" alt="Filter tables — 1. Click on &#x22;Filter&#x22;" width="1496" height="660" data-path="images/docs/uweckD9tRl88SZWrNHj5WFA2GXA.png" />

**Note:** the filters are case sensitive. A filter like "Job title" contains "Ceo" will not return the rows with "CEO" as a job title

You also have the option to apply multiple filters at the same time:

<img src="https://mintcdn.com/airscale/aXid-NqBkne9U7iH/images/docs/OPxi1GUOOjmtCMk9I55jFSZHSM.png?fit=max&auto=format&n=aXid-NqBkne9U7iH&q=85&s=f7cd0d371b04b5bc9456458169699c18" alt="Filter tables — 1. Click on &#x22;Filter&#x22;" width="1508" height="888" data-path="images/docs/OPxi1GUOOjmtCMk9I55jFSZHSM.png" />

And the option to replace the “AND” field with “OR” by clicking the small arrow on the right:

<img src="https://mintcdn.com/airscale/rvPtpUgeIpGkJ8m7/images/docs/4kdoQ1SUTCReCBTKYhywYhib5To.png?fit=max&auto=format&n=rvPtpUgeIpGkJ8m7&q=85&s=41965ec4ca4dc504e9c8badee8f7ad18" alt="Filter tables — 1. Click on &#x22;Filter&#x22;" width="1514" height="750" data-path="images/docs/4kdoQ1SUTCReCBTKYhywYhib5To.png" />

Once you’ve applied your filters, all you need to do is click on “Apply filters” and the table will update

**Note**: the more rows the table contains, the longer it will take to load and apply the filters

## 2. Another option: use the search bar to filter

You also have the option to use the search bar to look for a specific item within your table (this can be a first name, an email, a numeric field, or anything else):

<img src="https://mintcdn.com/airscale/k5o-AmvNyj_yzMcY/images/docs/i7APPi9NlgtHqK9TmsgxHLgchg.png?fit=max&auto=format&n=k5o-AmvNyj_yzMcY&q=85&s=c486f753fcb7858e35db22dc9772ab76" alt="Filter tables — 2. Another option: use the search bar to filter" width="2090" height="544" data-path="images/docs/i7APPi9NlgtHqK9TmsgxHLgchg.png" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.