You need to sign in to do that
Don't have an account?
HelloSan
unable to execute the following query? Is it something obvious? Custom_Object__c has a master relationship to Opportunity
[Select id,year__c,(select id,service_year__c from Order__r) From Opportunity];
Please go to Order object and then click on the field linked to the Opportunity. On the right hand side you will see 'Child Relationship Name', now copy this and append __r. And then use in the query.
For Example,
If the Child Relationship Name is abc, then the query should look like:
[Select id,year__c,(select id,service_year__c from abc__r) From Opportunity];
Please let me know if this helps.
If yes, please mark the question as Solved.
Thanks and Regards,
Anirudh Singh
All Answers
What is the name of your child object?
Thanks and Regards,
Anirudh Singh
[Select id,year__c,(select id,service_year__c from Orders__r) From Opportunity];
API Namer : Order__c
Please go to Order object and then click on the field linked to the Opportunity. On the right hand side you will see 'Child Relationship Name', now copy this and append __r. And then use in the query.
For Example,
If the Child Relationship Name is abc, then the query should look like:
[Select id,year__c,(select id,service_year__c from abc__r) From Opportunity];
Please let me know if this helps.
If yes, please mark the question as Solved.
Thanks and Regards,
Anirudh Singh