# How do I filter on a long list of emails or IDs

**URL:** https://community.omni.co/t/how-do-i-filter-on-a-long-list-of-emails-or-ids/187
**Category:** Patterns
**Created:** [November 12, 2024, 6:45pm UTC](https://community.omni.co/t/how-do-i-filter-on-a-long-list-of-emails-or-ids/187 "2024-11-12T18:45:20Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![jack](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/jack/32/14_2.png) [@jack](https://community.omni.co/u/jack)
#### Post date: [November 12, 2024, 6:45pm UTC](https://community.omni.co/t/how-do-i-filter-on-a-long-list-of-emails-or-ids/187/1 "2024-11-12T18:45:20Z")

</div>

The three main options here will be to (1) define a field where it creates a true/false flag that filters on those 1200, (2) use the filter by query functionality or (3) to drop them into the SQL statement directly.

For (2), you can build out a list of IDs that you want to filter down to in a tab, and then on a secondary tab add a filter on that field, select the filter by query option, and point it to the tab where you’ve reduced the list down. More information can be found [here](https://docs.omni.co/docs/querying-and-sql/querying#filter-by-another-query) in the docs.

You can quickly use an excel sheet to concatenate the single quotes `'` on either side as well with something like `CONCAT("'",A1,"',")` and then chaining those together to get a full list