Apex Code Development You need to sign in to do that
Don't have an account?
Ratheven Sivarajah How to query a custom object through a standard object using a soql
Hey Everyone, I am trying to do a query call to a child object and the parent object is a standard object. I am getting a error. Please help.
Thank you in Advance.
--------------This works standard object--------------
List<case> cas = [SELECT AccountId,CreatedById FROM case WHERE Id ='50005000005ym2OAAQ' ];
--------------This works custom object-------------------------
List<Quote_Request__c> req =[SELECT name FROM Quote_Request__c WHERE Id='a1505000000qzRjAAI'];
---------------This does not work---------------------------------
List<case> cases =[SELECT AccountId,CreatedById,(SELECT name FROM case.Quote_Request__c) FROM case WHERE Id ='50005000005ym2OAAQ']
Thank you in Advance.
--------------This works standard object--------------
List<case> cas = [SELECT AccountId,CreatedById FROM case WHERE Id ='50005000005ym2OAAQ' ];
--------------This works custom object-------------------------
List<Quote_Request__c> req =[SELECT name FROM Quote_Request__c WHERE Id='a1505000000qzRjAAI'];
---------------This does not work---------------------------------
List<case> cases =[SELECT AccountId,CreatedById,(SELECT name FROM case.Quote_Request__c) FROM case WHERE Id ='50005000005ym2OAAQ']
Do you have relationship between case and custom object?
If yes then try with below
If this helps, Please mark it as best answer.
Thanks!!