I'm hoping this is an easy one but I'm having no luck in developer console or workbench.
I have an object called Order_Line_Item__c
that is related to Order__c
which is related to Opportunity
which is then related to Account
. I'm trying to run the following:
SELECT Id, Order__r.Opportunity__r.AccountId, Document_Category__c, Quantity__c
FROM Order_Line_Item__c
WHERE Order__r.Opportunity__r.StageName = 'Closed Won'
In developer console this returns [object Object] with a column header of Order_r.Opportunity_r instead of the AccountId
. I run this exact same query in workbench and it returns my first 200 records great. But I try to return bulk csv and it fails saying:
Failed: InvalidBatch : Failed to process query: FUNCTIONALITY_NOT_ENABLED: Foreign Key Relationships not supported in Bulk Query
My end goal here is to group by AccountId
and sum the Quantity__c
for each unique Account
. This will give me the total products purchased by Account
. I can do multiple small queries, open in excel, run VLOOKUPs, and get my totals that way. But is there an easier way to do all of this? Any pointers or documentation would be appreciated.
Thanks in advance!