Apex Code Development You need to sign in to do that
Don't have an account?
Akash Deokar unable to query parent object field from opportunity
I have created one lookup field of custom object(Legal Entity) on opportunity object. Now i want records of opportunity where SAP code field is blank on Legal Entity Object.
I have written query as below but it is not getting executed.
Select id, name, Legal_Entity__r.SAP_CODE__c from opportunity
Error:Didn't understand relationship 'Legal_Entity__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
I have written query as below but it is not getting executed.
Select id, name, Legal_Entity__r.SAP_CODE__c from opportunity
Error:Didn't understand relationship 'Legal_Entity__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
Can you look for API name of relationship field name between opportunity and Legal Entity.(I mean to say lookup field API name which is created from Opportunity to Legal Entity)? if your lookup field api name is Legal_Entity__c then your query looks perfectly fine. And f that lookup field API name is something different then use that API name by appending __r while fetching records.
For Example my lookup relationship fileld name from opportunity to Legal Enity is Legal_Entity_rel__c, then my query will be change as follows:
List<Opportunity> opportunites = [Select id, name, Legal_Entity_rel__r.SAP_CODE__c from opportunity];
Let me know if it solves your problem and mark this answer as correct answer so that others can get help out of it.
All Answers
Can you look for API name of relationship field name between opportunity and Legal Entity.(I mean to say lookup field API name which is created from Opportunity to Legal Entity)? if your lookup field api name is Legal_Entity__c then your query looks perfectly fine. And f that lookup field API name is something different then use that API name by appending __r while fetching records.
For Example my lookup relationship fileld name from opportunity to Legal Enity is Legal_Entity_rel__c, then my query will be change as follows:
List<Opportunity> opportunites = [Select id, name, Legal_Entity_rel__r.SAP_CODE__c from opportunity];
Let me know if it solves your problem and mark this answer as correct answer so that others can get help out of it.