Now I would like to do the following:
zced__Interaction__cextract all the
Then for each of the extracted
zced__Assessment__cI would like to extract all the
zced__Assessment_Question__cwith the following fields (the fields actually do not matter in the case I suppose)
At the same time for each extracted
zced__Question_Instruction__cI would like to extract all
zced__Assessment_Answer__cwith the following fields (the fields here do not matter as well I think)
So, after reading this post I come up with the following solution (which does not work and I do not know how to fix it):
SELECT ( SELECT zced__Question_text__c, zced__Question_Instruction__c, ( SELECT zced__Answer_Text__c, zced__Is_Correct__c, zced__Answer_Points__c FROM zced__Assessment_Answer__c ) FROM zced__Assessment_Question__c ) FROM zced__Assessment__c WHERE zced__Interaction__c = :interactionId
What am I doing wrong here? The
interactionId is checked to be correct.
I am stuck while trying to implement the first step of the solution:
first query at the
List<sObject> l = [ SELECT Id, (SELECT Id FROM zced__Assessment_Question__c) FROM zced__Assessment__c WHERE zced__Interaction__c = :interactionId ];
It does not allow to query it this way. Why?