CSV Export wrong values

[zacksiri]

Kibana version: 7.17

Elasticsearch version: 7.17

Server OS version: Elastic CLoud

Browser version: Chrome 99

Browser OS version: MacOS 11.5.2

Original install method (e.g. download page, yum, from source, etc.):

Describe the bug:

CSV exported values do not match what is shown in Kibana

Steps to reproduce:

1. Index value with text
2. Go to discover add column
3. Export as CSV

Expected behavior:

The data should match, in the screenshot below, you can see what is being displayed in Kibana and on the right hand side it's the value in the CSV report generated from kibana. YOu'll see the last 3 digits are 000 and the 4th digit is -1. Something is not right.

Screenshots (if relevant):

Errors in browser console (if relevant):

Provide logs and/or server output (if relevant):

Any additional context:

[elasticmachine]

Pinging @elastic/kibana-reporting-services (Team:Reporting Services)

[tsullivan]

This looks to be a bug where reporting handles the numeric value by parsing it to a numeric type. It's my understanding that Discover is correctly showing the raw value, but Reporting is converting the value to a numeric type. Reporting's behavior is incorrect because JavaScript isn't able to handle number this high:

[tsullivan]

related: #40183

[tsullivan]

This issue is specific to when discover:searchFieldsFromSource is ON in Advanced Settings, and only affects CSV export.

[zacksiri]

@tsullivan thank you for looking into this. You pretty much nailed it and found the root cause of the issue.

[tsullivan]

Closing as a known issue with discover:searchFieldsFromSource. This setting is labeled as "soon to be deprecated" in the Advanced Settings UI, so I feel OK with leaving this unfixed.