CSV reports missing the Time field [BUG]

[Fran-Rg]

What is the bug?
When exporting from discover I would expect the Time field column is missing from the report

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Have an index pattern with a time field
2. Go to 'Discover'
3. Click on "Toggle column in table" for one field X
4. This should show you 2 columns: Time + the field X toggled
5. Click on 'Reporting > Download as CSV'
6. The CSV only contains the column X

What is the expected behavior?
The Time field should also be present

What is your host/environment?

• OS: AWS
• Version: v 2.11.0
• Plugins

Do you have any screenshots?
NA

Do you have any additional context?
I'm not sure if this is expected but it's been like this since the beginning

[pantinor]

We saw the same with latest versions and also opened a ticket here. Have you found any workaround or root cause ?

[dblock]

Catch All Triage - 1 2 3 4 5 6

[Tontonitch]

Facing the same issue with version 2.13.0.
xlsx export are also concerned.
So there is currently no way to add time / timestamps information into the exported data, making the export feature useless.
As a workaround, we had to recreate queries inside Query Workbench.

[frangabs]

In lastest version the same.

[GuruCat]

I'm using v 2.13.0 in AWS, I'm also facing same issue.

[smcueto]

Has a solution or workaround been shared? This is the closest forum to trying to figure out why dates are not being exported in the CSV.

[amirkkn]

Is any progress to this issue? It is somehow strange that issue exists at least since 7 months and no reaction

[joshuali925]

for now please see if this workaround works opensearch-project/reporting#668 (comment)

[markdboyd]

We are also experiencing this issue as well

[pburkholder]

Hi @joshuali925 and others (@TackAdam , @Swiddis , @rupal-bq -- to name a few contributors):

I hope you folks can devote some attention to this bug. Including @timestamp worked just fine in Kibana, and this bug is a significant issue as we (https://cloud.gov) migrate our customers to OpenSearch Dashboards.

Their experience with Dashboards has been largely positive, but asking them to open Web Developer and edit the POST request feels almost cruel, and doesn't reflect well on the other lovely features you've built here.

I'm not at all experienced with Typescript, but I'll try my best to submit a PR if that will help this work along.

Thanks and Happy Holidays!