I'm trying to group child records by their parent in a .PPT document. I can use SQOL to query to get the parent from the thild but this only lists either one group of child if i filter by <<parentId>> , or all children records in the template.
When I do a SOQL query to get children from the parent and make the row return as a table, it gives this error on save:
In the query, introduction custom object is the parent, selected offices is the child.
select id, Order__c, name, (SELECT Id, Name FROM Selected_Offices__r) from introduction__c where Related_Opportunity__c = '<<Opportunity_Id>>' and Include_in_Search_Report__c = true order by Order__c