ElasticSearch Date Range query returning all values

Question

I have created an index using below mapping.

Index Mapping:

{
  "mappings": {
    "document": {
        "properties": {
            "doc_date": {
          "type": "date" ,
          "format": "yyyy/MM/dd"
        }
      }
    }
  }
}

I indexed two records. Like below.

Records:

{
"doc_date": "2017/06/10",
"Record":"A"
}
{
"doc_date": "2017/05/10",
"Record":"D"
}

I wanted to select documents which are greater than or equal to date 2017/06/10.

Query:

{
    "query": {
        "range" : {
            "doc_date" : {
                "lte": "2017/06/10",
                "format": "yyyy/MM/dd"
            }
        }
    }
}

But the above query returned all the document in the index.

ElasticSearch version:5.0.2

you should use gte, not lte

Praneeth
– Praneeth

2017-09-25 11:14:36 +00:00
Commented Sep 25, 2017 at 11:14 — Praneeth
– Praneeth, Commented Sep 25, 2017 at 11:14

MartinSchulze · Accepted Answer · 2017-09-25 11:15:01Z

1

lte means lessthan or equal to the date. So you get all dates before 2017/06/10 and the date itself. You have to use gte which means greater-than or equal.

answered Sep 25, 2017 at 11:15

MartinSchulze

8971 gold badge7 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ElasticSearch Date Range query returning all values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related