search

forcedotcom / salesforcedx-vscode

Salesforce Extensions for VS Code
https://developer.salesforce.com/tools/vscode
BSD 3-Clause "New" or "Revised" License
953 stars 406 forks source link

CSV Export doesn't do anything #5054

Closed woodya-coder closed 1 year ago

woodya-coder commented 1 year ago

Summary

I do a simple query using SOQL Builder in VS Code. I can export the results as .json by clicking the Json button but clicking the .csv button does nothing. This isn't the case for all queries though.

Steps To Reproduce:

  1. Run this query - select assignee.firstname, permissionset.name from PermissionSetAssignment where isActive=TRUE
  2. Run the query
  3. Click the CSV button on the results table.

Expected result

Expected a Save As.. dialog to pop up and to be able to save the results.

Actual result

Nothing happened.

Additional information

Out of curiosity, I ran this query and I was able to export. I'm not sure what is different between the two.

select name from Lead where name like '%A%'

Salesforce Extension Version in VS Code: v58.13.1

SFDX CLI Version: sfdx-cli/7.206.6 win32-x64 node-v18.15.0

OS and version: Windows 11 Pro (10.0.22621 Build 22621)

daphne-sfdc commented 1 year ago

Hi @woodya-coder, The Support Team was unable to replicate your issue, both on Mac and Windows. But given the inconsistent behavior that you're seeing, I would try removing and reinstalling the SOQL extension, and then logging out of all orgs and re-authorizing to your current org. Let me know if that fixes the problem!

github-actions[bot] commented 1 year ago

This issue has not received a response in 7 days. It will auto-close in 7 days unless a response is posted.

john-kane commented 1 year ago

I was able to reproduce when querying Case records if the results were > 12 records returned. Per suggestions in thread, I uninstalled the SOQL extension, Reinstalled, deauthorized all orgs and re-authorized the sandbox org and still the CSV button didn't give me the save as prompt.

Additional info: If a related object is removed from the query, the 12 record limit is not an issue. For example, my Case query included Account.Name. When I removed that column the csv save as appeared when there were 2000 records returned.