# OR filter with Kibana 5.0

**URL:** <https://discuss.elastic.co/t/or-filter-with-kibana-5-0/65699>\
**Category:** Kibana\
**Created:** [November 10, 2016, 4:11pm UTC](https://discuss.elastic.co/t/or-filter-with-kibana-5-0/65699 "2016-11-10T16:11:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dav3860](https://avatars.discourse-cdn.com/v4/letter/d/f05b48/32.png) [@dav3860](https://discuss.elastic.co/u/dav3860)\
**Post date:** [November 10, 2016, 4:11pm UTC](https://discuss.elastic.co/t/or-filter-with-kibana-5-0/65699/1 "2016-11-10T16:11:59Z")

</div>

Hi,  
I used to create "bool" filters in Kibana to mimic an "OR". For example see :

> <https://stackoverflow.com/questions/30592608/or-filter-on-dashboard-in-kibana-4>

Since I upgraded to elasticsearch and Kibana 5.0, this doesn't work anymore. I imagine that it's because the bool filter was replaced by a bool query in elasticsearch 5.0 ([https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-filter.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-filter.html)). I can't get it to work.

Do you know how I can make an "OR" between two filters in ES/Kibana 5.0 ?

---

<div class="post-metadata">

**Author:** ![BigFunger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bigfunger/32/7323_2.png) [@BigFunger](https://discuss.elastic.co/u/BigFunger)\
**Post date:** [November 10, 2016, 9:25pm UTC](https://discuss.elastic.co/t/or-filter-with-kibana-5-0/65699/2 "2016-11-10T21:25:41Z")

</div>

I was able to modify a filter in 5.0 to achieve an OR filter.  
I changed it from a `match` query to a `query_string` query. [elasticsearch docs](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html)

 ![](https://us1.discourse-cdn.com/elastic/original/2X/a/aa5656f8c54ceab8d3474c6428d9f0666cea4e3b.gif)

**Original Filter:**

```auto
{
  "query": {
    "match": {
      "geo.dest": {
        "query": "CN",
        "type": "phrase"
      }
    }
  }
}

```

**Or Filter:**

```auto
{
  "query": {
    "query_string" : {
      "fields" : ["geo.dest"],
      "query" : "IN OR CN"
    }
  }
}

```

Will that work for you?

---

<div class="post-metadata">

**Author:** ![dav3860](https://avatars.discourse-cdn.com/v4/letter/d/f05b48/32.png) [@dav3860](https://discuss.elastic.co/u/dav3860)\
**Post date:** [November 14, 2016, 10:16am UTC](https://discuss.elastic.co/t/or-filter-with-kibana-5-0/65699/3 "2016-11-14T10:16:46Z")

</div>

Thank you ! It solved my problem.

---

<div class="post-metadata">

**Author:** ![BigFunger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bigfunger/32/7323_2.png) [@BigFunger](https://discuss.elastic.co/u/BigFunger)\
**Post date:** [November 14, 2016, 3:46pm UTC](https://discuss.elastic.co/t/or-filter-with-kibana-5-0/65699/4 "2016-11-14T15:46:03Z")

</div>

You're welcome!

---

<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:** [December 12, 2016, 3:46pm UTC](https://discuss.elastic.co/t/or-filter-with-kibana-5-0/65699/5 "2016-12-12T15:46:35Z")

</div>

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