Kibana not respect order by date why?

[Nikolas1306 (Nikolas “Nikolas”)]

in my index have this

    "message": "2022-10-08 19:36:24,452 INFO  [org.springframework.web.servlet.DispatcherServlet] (default task-1) Completed initialization in 15 ms",
    "@timestamp": "2022-10-19T19:07:49.010Z",
    "host": {
      "name": "cdrtestsinapsys"
    },
    "logdate": "2022-10-08T17:36:24.452Z",
    "input": {
      "type": "filestream"
    },
    "log": {
      "offset": 6449,
      "file": {
        "path": "/opt/wildfly/standalone/log/server.log.2022-10-08"
      }

but first record descending is "2022-07-27 @ 18:18:35.951"

is totals error is and really frustrating

[drewdaemon (Drew Tate)]

Hi @Nikolas1306 — sorry this is happening to you. Do you think you could post the Elasticsearch request Kibana is making?

[Nikolas1306 (Nikolas “Nikolas”)]

hello i've resolved with change the format of datatime in kibana system gui

tnx