Discover: Different datetime fields with different timezone

OpenSearch Dashboards Reporting Plugin
1

Hi all,

We are using OpenSearch 1.1.0 (the AWS managed version) in order to collect applicative logs.

A single log record contains different Timezone fields:

  • timestamp_local (ex. the time formatted with Europe/Rome timezone)
  • timestamp_utc (the time formatted in UTC)
{
   "tag":"my_tag",
   "timestamp_local" : "2022-07-12T10:57:21.201+02:00",
   "timestamp_utc" : "2022-07-12T08:57:21.201Z",
   "trace-id":"4bf92f3577b34da6a3ce929d0e0e4736",
   "span-id":"00f067aa0ba902b7",
   ....
   ....

When I search records through the “Dev Tools” functionality or by calling the Opensearch APIs, I see these time fields with the right values. Instead, when I search records through the “Discover” functionality, I see that all these time fields are automatically formatted in UTC.

Immagine
Immagine1889×1035 95.7 KB

Is there a way to show the original time fields also with Discover functionality?

Thank you