Kibana discover does not filter the time field correctly

I have an index where the timestamp filed called start mapped as:
"start": {
"type": "date",
"format": "yyyy.MM.dd HH:mm:ss Z"
}

When I click on the filter button next to the value the filter gives no result.

Like this:

The version of ES and Kibana is 6.1.2.
Thanks in advance!

Can you look at the request that It's done in the last screenshot?
I'd be curious to look at this part of the request:

  "query": {
    "bool": {
      "must": [
        {
          "match_all": {}
        },
        {
          "match_phrase": {
            "@timestamp": {
              "query": "2019-01-22T13:38:16.756Z"
            }
          }
        },
        {
          "range": {
            "@timestamp": {
              "gte": 1546293600000,
              "lte": 1577829599999,
              "format": "epoch_millis"
            }

Sounds like a problem with timezone conversions but it needs more investigation.

The strangest thing in it: If I filter out a certain timestamp (with the minus lens icon) I get also no result and I get a warning message at the top like this: "Courier Fetch: 3 of 347 shards failed."

BTW, I have executed the query you have mentioned - it gave no result at all.

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