+ Start a Discussion
Yogesh BiyaniYogesh Biyani 

How to download the developer console query results?

Following query results in 17000+ records. How do I save this result to csv/excel file? I tried SDFC Dev Console Data Exporter  but is saves only about 1000 rows. 
SELECT 
    CreatedDate,Id, Owner.Name,Inquiry_Type__c,
(SELECT id FROM EmailMessages 
WHERE Incoming = true)
FROM Case WHERE Sales_Department__c='Sales' AND Response_Indicator__c=TRUE
Raj VakatiRaj Vakati
I dnt think so you can able to do it .. try to use workbench and export from there 
mritzimritzi
open workbench: https://workbench.developerforce.com
Select (Production/Sandbox) depending on from where you've to export csv file and login.
(If you are using free Developer org, select 'Production')
From Menu, select Query -> soql Query
Follow the image, click on 'Query' button. In the next screen, you'll be able to download the file.
workbench

Please mark this as BEST ANSWER, id this helps solve your problem.
Yogesh BiyaniYogesh Biyani
Hello Mritzi,

I tried workbench but get "InvalidJob: Unable to find object: EmailMessages". If I recall correctly workbench does not support nested queries. 

User-added image

I was able to use G-Connector for Salesforce and get the results in Google Sheets.

Yogesh