# Range query elasticsearch

**URL:** <https://discuss.elastic.co/t/range-query-elasticsearch/65605>\
**Category:** Elasticsearch\
**Created:** [November 10, 2016, 8:42am UTC](https://discuss.elastic.co/t/range-query-elasticsearch/65605 "2016-11-10T08:42:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aniketpatil](https://avatars.discourse-cdn.com/v4/letter/a/85f322/32.png) [@aniketpatil](https://discuss.elastic.co/u/aniketpatil)\
**Post date:** [November 10, 2016, 8:42am UTC](https://discuss.elastic.co/t/range-query-elasticsearch/65605/1 "2016-11-10T08:42:01Z")

</div>

I have written following query to get data from elasticsearch.

```
SearchRequest requestQuery =
      Requests.searchRequest(ConstantsValue.indexName)
       .types(ConstantsValue._Type)
       .source("{size:999999,"
         + "\"_source\" : "
          + "[\"DTCREATED\", \"STATUS\"]"
          + ",\"aggs\": "
          + "{\"group_by_STATUS\": {\"terms\": {\"field\": \"STATUS\"},"
          + "\"aggs\" : "
          + "{\"group_by_DATE\" : {\"date_histogram\" : "
          + "{\"field\" : \"DTCREATED\", \"interval\" : \"day\","
          + "\"format\" : \"yyyy-MM-dd\" },"
          + "\"aggs\" : "
          + "{\"grades_count\" : { \"value_count\" : { \"field\" : \"STATUS\" } }}}}}}}");

```

This query gives me day wise count of status. But now I want to add date range lets say from 2016-09-01T18:30:00.000Z to 2016-10-01T18:30:00.000Z. I want daily status count for that date range. I have tried my best but not found any answer. Any help is greatly appreciated

---

<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 8, 2016, 8:42am UTC](https://discuss.elastic.co/t/range-query-elasticsearch/65605/2 "2016-12-08T08:42:10Z")

</div>

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