You need to sign in to do that
Don't have an account?
Nested SOQL Queries (more than 1 level Parent-to-child queries)
Hi, Folks!
Does anybody know how to make more than 1 level nested Parent-to-Child query?
As I know there is a standard limitations for parent-to-child queries: "In each specified relationship, only one level of parent-to-child relationship can be specified in a query."
Sure I can provide some additional classes to solve the problem, but maybe somebody knows another way?
(kind of how to make additional request for query resulds:
companiesList.addAll([
Select Name, c.Conference__r.Id, c.Conference__c, c.Comapny_Contact__r.FirstName,
(Select Name From PC_Track__r)
From cmp_Participating_Company__c c
Where c.Conference__r.Id = 'a00A0000000q5nK'
]);
for (cmp_Participating_Company__c company : companiesList)
{
for (cmp_Meeting_Track__c track : company.PC_Track__r)
{
track.Meeting_Track__r = [Select Name From cmp_Meeting__c];
}
}
)