Grandparent - Parent - Child relationships in SOQL query
10:30 AM
I had to write a SOQL query to fetch values form multiple objects related together. I thought it could be done easily using Nested SOQL queries, but it was not possible. Nested queries could be only 1 Level deep. So, the below query doesn't work.
Whereas, this one works
List<Grandparent__c> parentnodes = [Select Name,
(Select Name,(Select Name from Grandparent__c.Parent__c.Child__r)
From Grandparent__c.Parent__r) from Grandparent__c];
Whereas, this one works
List<parent__c> parentnodes = [Select Name,
(Select Name From parent__c.Child__r) from parent__c
];
0 comments