# Most efficient way to limit search result to List of Ids
**URL:** https://discuss.elastic.co/t/most-efficient-way-to-limit-search-result-to-list-of-ids/261082
**Category:** Elasticsearch
**Tags:** language-clients
**Created:** [January 14, 2021, 6:57am UTC](https://discuss.elastic.co/t/most-efficient-way-to-limit-search-result-to-list-of-ids/261082 "2021-01-14T06:57:31Z")
**Posts on this page:** 2
**Page:** 1
I am working on an e-commerce website. I have an index called `AdDocument` which is the products that are synched to Elasticsearch. Each product belongs to a category.
Now I want to write a query to get all products which belong to certain categories... for example, assuming I have the following categories:
- _Category: Fashion, CategoryId: 1_
- _Category: Sports, CategoryId: 2_
- _Category: Movies, CategoryId: 3_
- _Category: Books, CategoryId: 4_
- _Category: Furnitures, CategoryId: 5_
- _Category: Real Estate, CategoryId: 6_
- _Category: Jobs, CategoryId: 7_
- _Category: Services, CategoryId: 8_
- _and so on..._
I want to get all the products which belong to _Fashion, Sports, Movies_ or _Books_ category, so I would call the following method:
`GetQuery(new List {1, 2, 3, 4}); // <-- Limit result to CategoryIds 1, 2, 3 or 4`
Using NEST, I have managed to achieve this using 2 different approaches:
1. Write a query for each category and logically `OR` all of them:
```auto
public QueryContainer GetQuery(List categoryIds)
{
var queries = new List();
foreach (var categoryId in categoryIds)
{
var query = new TermQuery
{
Name = "Multi Category Filter",
Field = Field(p => p.CategoryId),
Value = categoryId
};
queries.Add(query);
}
return queries.Aggregate((current, next) => (current || next));
}
```
1. Use `TermsQuery` and pass the `CategortIds` for `Terms`:
```auto
public QueryContainer GetQuery(List categoryIds)
{
var query = new TermsQuery
{
Name = "Multi Category Filter",
Field = Field(p => p.CategoryId),
Terms = categoryIds.Cast