Elasticsearch query dates while using the querystring

Question

I want to to query in the dats while using the querystring.

From what I can read here this should work.

{
    "query": {
        "query_string": {
            "query": "date:[20100101 TO 20141231]"

        }
    },
    "size": 10

}

I get no errors but no results either.

I have date fields in the mapping (shortened for your convenience).

{
   "cases": {
      "mappings": {
         "texcaseelastic": {
            "properties": {
               "dateIn": {
                  "type": "date",
                  "format": "dateOptionalTime"
               },
               "type": {
                  "type": "string"
               }
            }
         }
      }
   }
}

And I have at least a few that should fall in that range.

"dateIn": "2011-11-21T00:00:00",

Any help would be welcome. Thanks.

Is that a typo in your query, that your field name is date instead of dateIn? — Paige Cook
– Paige Cook, Commented May 15, 2014 at 16:08
No, that is how I understand it to work, I thought date meant all fields with a date in them. But you are saying that that should be my fieldname datin? — chrissie1
– chrissie1, Commented May 15, 2014 at 18:10
darn, stupid me. Can you make that an answer so I can accept it? — chrissie1
– chrissie1, Commented May 15, 2014 at 18:13
can I do a search on all date fields for a date with the querystring — chrissie1
– chrissie1, Commented May 15, 2014 at 18:16

Paige Cook · Accepted Answer · 2014-05-15 18:55:23Z

6

There is a typo in your query. You are doing a search by specific field and your field name is incorrect.

Change date to dateIn, like the following:

{
    "query": {
        "query_string": {
            "query": "dateIn:[20100101 TO 20141231]"

        }
    },
    "size": 10

}

answered May 15, 2014 at 18:55

Paige Cook

22.6k3 gold badges60 silver badges68 bronze badges

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

Comments

ss301 · Accepted Answer · 2022-07-15 13:35:55Z

0

{
    "query":{"range": {"date_column_name": {"gte": "2011-11-20T00:00:00", "lte": "2011-11-22T00:00:00"}}},
    "size": 10
}

answered Jul 15, 2022 at 13:35

ss301

6821 gold badge11 silver badges25 bronze badges

Collectives™ on Stack Overflow

Elasticsearch query dates while using the querystring

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related