# Filtering for multiple values of a single field

**URL:** <https://discuss.elastic.co/t/filtering-for-multiple-values-of-a-single-field/97584>\
**Category:** Kibana\
**Created:** [August 18, 2017, 12:52pm UTC](https://discuss.elastic.co/t/filtering-for-multiple-values-of-a-single-field/97584 "2017-08-18T12:52:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sLuvpreet33](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sluvpreet33/32/50626_2.png) [@sLuvpreet33](https://discuss.elastic.co/u/sLuvpreet33)\
**Post date:** [August 18, 2017, 12:52pm UTC](https://discuss.elastic.co/t/filtering-for-multiple-values-of-a-single-field/97584/1 "2017-08-18T12:52:22Z")

</div>

I have a status field, which can have one of the following values,

![image(4)](https://us1.discourse-cdn.com/elastic/original/3X/1/9/19c79f9944fda81566bc39c426613ca1921edeaa.jpg)

I can filter for data which have status completed. I can also see data which has ongoing.

But I want to display only the data which have status **completed** and **ongoing** at the same time.

But I don't know how to add filters for 2 values on a single field.

How can I achieve what I want ?

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [August 18, 2017, 7:35pm UTC](https://discuss.elastic.co/t/filtering-for-multiple-values-of-a-single-field/97584/2 "2017-08-18T19:35:45Z")

</div>

What about just using an `OR` in the filter?

```auto
booking_status:(completed OR ongoing)

```

See: [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#query-string-syntax](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#query-string-syntax)

---

<div class="post-metadata">

**Author:** ![sLuvpreet33](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sluvpreet33/32/50626_2.png) [@sLuvpreet33](https://discuss.elastic.co/u/sLuvpreet33)\
**Post date:** [August 19, 2017, 6:28am UTC](https://discuss.elastic.co/t/filtering-for-multiple-values-of-a-single-field/97584/3 "2017-08-19T06:28:39Z")

</div>

Yeah Cool.

But how can I use it in kibana ?

 ![image(4)](https://us1.discourse-cdn.com/elastic/original/3X/3/b/3b262878c0ea2e73c03e26b0af145983d1de34ae.jpg)

Like here I have filtered for `status:completed`, can I put 2 filters like this ?

I know I can edit this query, but I need a simpler way to show it to my marketing team(which have no idea about editing this query), and I need a simple way to convince them.

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [August 21, 2017, 4:51pm UTC](https://discuss.elastic.co/t/filtering-for-multiple-values-of-a-single-field/97584/4 "2017-08-21T16:51:08Z")

</div>

You can type the filter in the bar with the "Filter ..." text.

It looks like you are using Kibana 5.x, but stay tuned for huge improvements to the query bar coming in 6.0: [https://www.elastic.co/guide/en/kibana/6.0/kuery-query.html](https://www.elastic.co/guide/en/kibana/6.0/kuery-query.html) The new "Kuery" functionality should make it easier for the Marketing team. 😉

---

<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:** [September 18, 2017, 4:51pm UTC](https://discuss.elastic.co/t/filtering-for-multiple-values-of-a-single-field/97584/5 "2017-09-18T16:51:28Z")

</div>

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