[FEATURE] Discover Reporting - included timestamp field when generating CSV

[ryn9]

Is your feature request related to a problem? N/A

What solution would you like? Currently - when generating a CSV from Discover, the timestamp is not included in the output. Please include the displayed timestamp in the output.

What alternatives have you considered? manually adding the timestamp to the display fields, therefore displaying the time twice in Discover, but only once in the output is what I have been using to work around this limitation.

Do you have any additional context? N/A

[ryn9]

@joshuali925 any questions about the request? Did I provide enough information?

[joshuali925]

@ryn9 i believe this is what you meant, correct me if i'm wrong: discover displays an additional Time column regardless of fields selected. this extra logic is not in reporting, so it only shows selected fields

i'm currently working on something else and i'll see when i can get to this. if you are interested, feel free to take a look and send a PR. i think here we need to include the time field into selected fields https://github.com/opensearch-project/dashboards-reporting/blob/df8b413ae12ee6ac237392246a9da4e5e858eac5/server/routes/utils/dataReportHelpers.ts#L148

[ryn9]

@joshuali925 - any update on this ?

[henceiam]

@joshuali925 I am also curious if there is any plans for this?

[zawadaa]

Exporting to CSV without timestamps in most cases are useless :-(