Can I also export some fields from the referenced parent sObjects using the child object query?
Question.
I have a parent object ParentObject__c and want to get all ParentObject__r.Name using the child query on the ChildObject__c.
In my configuration:
- The ChildObject__c is the child object
- The ParentObject__c is the parent.
I am trying to use this query, but it's not working:
SELECT Name, ParentObject__r.Name FROM ChildObject__c
What is wrong ?
Answer.
You cant use subqueries and dots in your query. Use only the fields which owned by the object itself.
In order to extract the names of only those ParentObject__c records, which are related to the ChildObject__c records, create export.json containing two different objects with the following queries:
# Query defined for the ChidObject__c, ParentObject__c is a lookup field to the ParentObject__c object
SELECT Name, ParentObject__c FROM ChildObject__c
# Query defined for the ParentObject__c
SELECT Name FROM ParentObject__c
master=false # this is required, since we want to select all parent records which are referenced by the child records
Set master = false for the ParentObject__c object.