Categories
Dashboard Report export generating data in incorrect column order

Summary:
Report export generating data in incorrect column order
Content (required):
Hi,
Customer is trying to export the dashboard table report in csv file, but after export, column is not having the same order as we see in report. Please suggest how to get correct export column order as we see in the report.
Version (include the version you are using, if applicable):
OAS 5.9
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi Mandar,
Check the order of the columns in the Criteria. The export gets generated in the order of the columns present in the criteria. If you have a specific order in which the columns need to be in the export, set the order in the Criteria itself.
0 -
What Amrita said.
There are 2 kinds of exports: one that goes directly on the criteria and does export your criteria (all the columns you have there) and one that is based on the visual rendering of the view as you see it on your screen (and therefore can have less columns because some are excluded etc.).
CSV is an export based on the criteria definition, it's the expected behavior and does work like that for (many) years.
0