Salesforce-Inspector-reloaded icon indicating copy to clipboard operation
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

Open bonzi-123 opened this issue 4 months ago • 0 comments

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:

Screenshot 2024-10-05 at 10 15 47

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):

Screenshot 2024-10-05 at 10 21 56

I attach the Excel file here with these two Ids highlighted: Example 1.xlsx

Example 2 (2 subqueries, Orders and Contacts):

Screenshot 2024-10-05 at 11 07 33

When I copy it into Excel, some of the values of the Contacts subquery appear in the Orders subquery columns:

Screenshot 2024-10-05 at 11 08 33

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.

bonzi-123 avatar Oct 05 '24 09:10 bonzi-123