# How to do 2 range query like a OR condition, give result satisfy any one condition

**URL:** <https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312>\
**Category:** Elasticsearch\
**Created:** [May 17, 2018, 10:46am UTC](https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312 "2018-05-17T10:46:49Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![varun1992](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@varun1992](https://discuss.elastic.co/u/varun1992)\
**Post date:** [May 17, 2018, 10:46am UTC](https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312/1 "2018-05-17T10:46:49Z")

</div>

Hi i have 2 range queries like below

```
{ "range": { "@timestamp": { "gte": "05-16-2018", "lt": "05-17-2018", "format": "MM-dd-yyyy" } }}

{ "range": { "@timestamp": { "gte": "05-13-2018", "lt": "05-14-2018", "format": "MM-dd-yyyy" } }}

```

how can i create a query which give result , which satisfy any one condition ,like a OR query ?

I tried like below, but it's result was like AND condition

```
{ "query" :
{ "bool": { "must": [
 { "range": { "@timestamp": { "gte": "05-16-2018", "lt": "05-17-2018", "format": "MM-dd-yyyy" } }},
 { "range": { "@timestamp": { "gte": "05-13-2018", "lt": "05-14-2018", "format": "MM-dd-yyyy" } }}
           ]      
      }
  }

```

}

please help me to create query . Thanks

---

<div class="post-metadata">

**Author:** ![RahulD](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@RahulD](https://discuss.elastic.co/u/RahulD)\
**Post date:** [May 17, 2018, 10:51am UTC](https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312/2 "2018-05-17T10:51:45Z")

</div>

Take a look at bool query's should block: [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html)

---

<div class="post-metadata">

**Author:** ![varun1992](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@varun1992](https://discuss.elastic.co/u/varun1992)\
**Post date:** [May 17, 2018, 12:10pm UTC](https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312/3 "2018-05-17T12:10:58Z")

</div>

```
{ "query" :
{ "bool": { "must": [
{"bool": { "should": [
 { "range": { "@timestamp": { "gte": "05-16-2018", "lt": "05-17-2018", "format": "MM-dd-yyyy" } }},
 { "range": { "@timestamp": { "gte": "05-13-2018", "lt": "05-14-2018", "format": "MM-dd-yyyy" } }}
       ] }} ]      
      }
  }

```

Is this okay ? anything wrong

---

<div class="post-metadata">

**Author:** ![RahulD](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@RahulD](https://discuss.elastic.co/u/RahulD)\
**Post date:** [May 17, 2018, 12:30pm UTC](https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312/4 "2018-05-17T12:30:20Z")

</div>

It was missing a closing bracket at the end, other than that looks fine.

```
{
  "query": {
    "bool": {
      "must": [
        {
          "bool": {
            "should": [
              {
                "range": {
                  "@timestamp": {
                    "gte": "05-16-2018",
                    "lt": "05-17-2018",
                    "format": "MM-dd-yyyy"
                  }
                }
              },
              {
                "range": {
                  "@timestamp": {
                    "gte": "05-13-2018",
                    "lt": "05-14-2018",
                    "format": "MM-dd-yyyy"
                  }
                }
              }
            ]
          }
        }
      ]
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![varun1992](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@varun1992](https://discuss.elastic.co/u/varun1992)\
**Post date:** [May 17, 2018, 2:51pm UTC](https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312/5 "2018-05-17T14:51:33Z")

</div>

Thanks for the information

---

<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:** [June 14, 2018, 2:51pm UTC](https://discuss.elastic.co/t/how-to-do-2-range-query-like-a-or-condition-give-result-satisfy-any-one-condition/132312/6 "2018-06-14T14:51:36Z")

</div>

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