Salesforce-Inspector-reloaded
Salesforce-Inspector-reloaded copied to clipboard
[data-export] When copying to Excel/CSV a result with a subquery where "Hide Object Columns" has been selected, pasting has incorrect data
Make sure to read the troubleshooting section before creating an issue
- [x] I've read the common issues and the one I'm about to create is not one of those documented.
- [x] I've read the release note and the one I'm about to create is not already fixed.
Describe the bug When copying to Excel/CSV a result with a subquery where "Hide Object Columns" has been selected, pasting has incorrect data. The information appears correctly in the "Data Export" table, but not when pasting it outside.
For example:
Example 1 (subquery on Orders):
Here is a screenshot of the the results I see in the Data Export tool:
However, when I copy it into Excel I see some values that don't belong to those columns (the Ids that are out of place seem to be coming from the "LastModifiedId" column):
I attach the Excel file here with these two Ids highlighted: Example 1.xlsx
Example 2 (2 subqueries, Orders and Contacts):
When I copy it into Excel, some of the values of the Contacts subquery appear in the Orders subquery columns:
I also attach the Excel File: Example 2.xlsx
When copying the data from the Data Export tool when "Hide Object Columns" is NOT selected, the information gets copied correctly to Excel.