ElasticSearch date range

Question

I have the following query:

{
   "query": {
     "query_string": {
       "query": "searchTerm",
        "default_operator": "AND"
       }
     },
    "facets": {
      "counts": {
        "date_histogram": {
         "field": "firstdate",
         "interval": "hour"
         }
    }
}

and I would like to add a date range to it, so as to retrieve values for the field firstdate which are within a specific from/to interval. Any suggestions on how to do it? Many thanks!

score 39 · Accepted Answer · edited Apr 30 '19 at 13:29

you just need to add a range filter to your query:

{
"query":{
  "filtered": {
     "query": {
       "query_string": {"query": "searchTerm", "default_operator": "AND" }
     },
      "filter" : {
         "range": {"firstdate": {"gte": "2014-10-21T20:03:12.963","lte": "2014-11-24T20:03:12.963"}}
    }
  }
},
"facets": {
 "counts": {
    "date_histogram": {
       "field": "firstdate",
       "interval": "hour"
      }
    }
  }
}

maximus ツ · Answer 2 · 2014-11-12T17:32:05.963

23

Boolean query will work too,

 {
   "query" :{
      "bool" : {             
          "must" : {
              "range": {"firstdate": {"gte": "2014-10-21T20:03:12.963","lte": "2014-11-24T20:03:12.963"}}
          },

          "must" : {
            "query_string": {
              "query": "searchTerm",
              "default_operator": "AND"
            }
          }

      }
    },

   "facets": {
       "counts": {
          "date_histogram": {
             "field": "firstdate",
             "interval": "hour"
           }
        }
    }

 }

edited Nov 12 '14 at 17:32

answered Nov 07 '14 at 14:59

maximus ツ

7,949
3
25
54

Where is the `"firstdate"` coming from? It's not in the docs. – Daniel Lizik Dec 16 '15 at 21:41
@Daniel_L, that was just example. Sorry if I confused you. – maximus ツ Dec 17 '15 at 10:23
`firstdate` could very well be something like `@timestamp`. It differs per index – Joviano Dias Apr 05 '17 at 10:36
3

Filtered now is deprecated. https://www.elastic.co/guide/en/elasticsearch/reference/5.0/query-dsl-filtered-query.html – abkrim Sep 29 '17 at 08:06

score 9 · Answer 3 · answered Sep 24 '19 at 07:00

This query displays the results which appears in the given date range. "date_field_name" is the field name on which you want to set date range filters.

GET index_name/_search
{
  "query": {
    "bool": {
      "must":[ 
              {
                "range": {
                  "date_field_name": {
                    "gte": "2019-09-23 18:30:00",
                    "lte": "2019-09-24 18:30:00"
                  }
                }
              }
      ]
    }
  },
  "size": 10
}

score 4 · Answer 4 · answered Apr 10 '20 at 06:27

https://your_elasticsearch/your_index PUT

     {
        "mappings": {
            "properties": {
                "created_at": {
                    "type": "date",
                    "format": "yyyy-MM-dd HH:mm:ss"
                }
            }
        }
    }

https://your_elasticsearch/your_index/_search POST

  {
    "query": {
        "bool": {
            "filter": [
                {
                    "range": {
                        "created_at": {
                            "gte": "2020-04-01 08:03:12",
                            "lte": "2020-04-01 20:03:12"
                        }
                    }
                }
            ]
        }
    }
}

ElasticSearch date range

4 Answers4

Linked