Apex Code Development You need to sign in to do that
Don't have an account?
jpben DataLoader - Command Line Interface
We have a report that I am trying to extract automatically to a csv file. I typically use the Command Line Interface (using DataLoader) to do this. However, this particular report uses a Report Type of "Opportunities w/ Products". I dont think DataLoader can do a nested SOQL query. Any suggestions how i can automate extraction of data if the information is pulling from 2 objects.
SELECT CloseDate, Name, Generics_Analyst__c,(SELECT Site__c,Quantity,Approved_QTY__c,Disposition__c,Product_Name__c,Status__c FROM OpportunityLineItems) FROM Opportunity
WHERE RecordTypeId = '012G00000015ChQ' AND StageName != 'FSE Created' AND CloseDate = TODAY
SELECT CloseDate, Name, Generics_Analyst__c,(SELECT Site__c,Quantity,Approved_QTY__c,Disposition__c,Product_Name__c,Status__c FROM OpportunityLineItems) FROM Opportunity
WHERE RecordTypeId = '012G00000015ChQ' AND StageName != 'FSE Created' AND CloseDate = TODAY
Try running this query on workbench. In data loader you can work on only one object at a time.
In workbench you can export the query results in csv.