Query Url - Date field not works

Elastic Stack Elasticsearch
1

Hi guys,

I'm trying to create a url query with a date field.
Currently in the index I have 2 date fields "@timestamp" and "CALL_DATE" both correctly recognized as "date".
Index mapping:

{
  "cgw_calls" : {
    "mappings" : {
      "properties" : {
        "@timestamp" : {
          "type" : "date"
        },
        "@version" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        "INSTITUTE" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        "type" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        "CALL_DATE" : {
          "type" : "date"
        }
      }
    }
  }
}

URL query (works fine):

http://localhost:9200/cgw_calls/_search?default_operator=AND&q=INSTITUTE:*+@timestamp:[2023-03-01+TO+2023-03-31]&size=0&track_total_hits=true

URL query (not works):

http://localhost:9200/cgw_calls/_search?default_operator=AND&q=INSTITUTE:*+CALL_DATE:[2023-03-01+TO+2023-03-31]&size=0&track_total_hits=true

If I use the same filter with @timestamp it works, with CALL_DATE it doesn't.

Can you help me understand why it doesn't work?

2

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