# Multiple items query Kibana

**URL:** <https://discuss.elastic.co/t/multiple-items-query-kibana/139322>\
**Category:** Kibana\
**Created:** [July 10, 2018, 10:18am UTC](https://discuss.elastic.co/t/multiple-items-query-kibana/139322 "2018-07-10T10:18:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![espogian](https://avatars.discourse-cdn.com/v4/letter/e/4491bb/32.png) [@espogian](https://discuss.elastic.co/u/espogian)\
**Post date:** [July 10, 2018, 10:18am UTC](https://discuss.elastic.co/t/multiple-items-query-kibana/139322/1 "2018-07-10T10:18:34Z")

</div>

Hi there, I have a dumb question but I can't find the right solution.  
I have to add a filter in a Kibana visualization with the procedure Add a filter --\> type is one of --\> Values.

My first issue is that the list of possible types is too long to add them manually.  
I think that the best option would be to edit the Query DSL json.

However, my second issue is that afterwards I get a URL overflow.

Which is the correct way to deal with these huge filters?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [July 10, 2018, 11:41am UTC](https://discuss.elastic.co/t/multiple-items-query-kibana/139322/2 "2018-07-10T11:41:10Z")

</div>

What is it you are trying to do? What does your data look like? What is the purpose of these huge filters?

---

<div class="post-metadata">

**Author:** ![espogian](https://avatars.discourse-cdn.com/v4/letter/e/4491bb/32.png) [@espogian](https://discuss.elastic.co/u/espogian)\
**Post date:** [July 10, 2018, 12:17pm UTC](https://discuss.elastic.co/t/multiple-items-query-kibana/139322/3 "2018-07-10T12:17:39Z")

</div>

Hi @Christian_Dahlqvist,

I have an index on Elasticsearch which is basically a collection of events containing a series of the following information:

```
time_stamp
id
property1
property2
...
propertyN

```

And I created a series of Visualizations on Kibana, e.g. the line chart of the average of propertyN by time\_stamp.

What I would like to do is to add a filter on a visualization showing only a list of possible ids. But this list is fairly long (more than 1000 items) so it is not practical to add them manually.

Thank you

---

<div class="post-metadata">

**Author:** ![espogian](https://avatars.discourse-cdn.com/v4/letter/e/4491bb/32.png) [@espogian](https://discuss.elastic.co/u/espogian)\
**Post date:** [July 10, 2018, 12:33pm UTC](https://discuss.elastic.co/t/multiple-items-query-kibana/139322/4 "2018-07-10T12:33:03Z")

</div>

Even customizing the Query DSL by hand and enabling the advanced setting `state:storeInSessionStorage` I'm getting the following error: `Visualize: Request Entity Too Large`

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 7, 2018, 12:33pm UTC](https://discuss.elastic.co/t/multiple-items-query-kibana/139322/5 "2018-08-07T12:33:04Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.