Elasticsearch query greater than date

Question

I create an index and it save two date (D1, D2) for something, after that I want to query this monent is it between D1 and D2, so I query :

startdate <= "2019-08-22T03:55:47.165Z" AND endate>= "2019-08-22T03:55:47.165Z"

It successful return the data as I want, so I try to do the same things in Dev tools again with:

GET i_want_get_date/_search
{
  "query":{
    "query_string":{
      "query":"startdate<= \"2019-08-22T03:55:47.165Z\" AND enddate>= \"2019-08-22T03:55:47.165Z\""
    }
  }
}

The problem is:

it cannot search any result back, the query cannot compare the date using this method

Any suggestion? Thanks!

============================================================

Thanks Val answer the question, I using a very slimier query to do the same function, I change a little bit query syntax to make it works:

GET i_want_get_date/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "startdate":{
              "lte":"2019-08-22T03:55:47.165Z"
            }
          }
        },
        {
          "range": {
            "enddate":{
              "gte":"2019-08-22T03:55:47.165Z"
            }
          }
        }
      ]
    }
  }
}

use range query elastic.co/guide/en/elasticsearch/reference/current/… — rohit prakash
– rohit prakash, Commented Aug 22, 2019 at 4:43

Val · Accepted Answer · 2024-01-23 08:49:27Z

15

I suggest to use two range queries instead

GET i_want_get_date/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "startdate": {
              "gte": "2019-08-21T03:55:47.165Z"
            }
          }
        },
        {
          "range": {
            "enddate": {
              "lt": "2019-08-22T03:55:47.165Z"
            }
          }
        }
      ]
    }
  }
}

edited Jan 23, 2024 at 8:49

answered Aug 22, 2019 at 5:50

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

Yuk_dev Over a year ago

@VaI Thanks for answer the question, base on your suggestion I find the way to query it !

gil.fernandes · Accepted Answer · 2023-01-16 14:29:57Z

2

This is the query that worked for me to select dates after based on a specific field:

{
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "_kuzzle_info.createdAt": {
              "gte": "2023-01-09T13:29:27.537+00:00"
            }
          }
        }
      ]
    }
  }
}

_kuzzle_info.createdAt is the field with the date

answered Jan 16, 2023 at 14:29

gil.fernandes

14.8k7 gold badges78 silver badges88 bronze badges

Comments

danish_wani · Accepted Answer · 2022-11-10 15:45:37Z

0

there is a syntax error in your answer, the elastic fields should come before the gte or lte

{
   "range": {
         "**startdate**": {
              "**lte**": "2019-08-22T03:55:47.165Z"
          }
      }
}

answered Nov 10, 2022 at 15:45

danish_wani

88210 silver badges14 bronze badges

Comments

Ajit Surendran · Accepted Answer · 2023-03-23 07:43:52Z

0

If nested fields, then below query will work. Make sure the schedule data type is 'date'

"query": {
    "bool": {
      "filter": {
        "nested": {
          "path": "trans",
          "query": {
            "range": {
              "trans.schedule": {
                "lte": "2023-03-23T00:35:45"
              }
            }
          }
        }
      }
    }
  }
}

answered Mar 23, 2023 at 7:43

Ajit Surendran

7877 silver badges4 bronze badges

Collectives™ on Stack Overflow

Elasticsearch query greater than date

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related