Apex Code Development You need to sign in to do that
Don't have an account?
Rafael.Martins.Santos How get a parent data from a child object?
Hi,
I have a custom object child of the opportunity object.
I want make a SOQL from the child to get the data of the Opportunity.
Someone know how I do that?
Some best practice in this case.
Thanks
Rafael
I have a custom object child of the opportunity object.
I want make a SOQL from the child to get the data of the Opportunity.
Someone know how I do that?
Some best practice in this case.
Thanks
Rafael
You will have to replace the Opportunity__r with the field api name for example the api of the field is opp__c then use as opp__r.Name to get the opportunity name.
Hope this clears the thing.
Please let me know if it solves the problem.
Regards,
Ashish Kr.
All Answers
You could use child - parent soql as below
For(Contact c:[select Name,Account.Name from Contact]) { system.debug('Contact Name :'+ c.Name +' Account Name:' +c.Account.Name); }Please go through below link to read more about relationship queries.
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_query_using.htm
Regards,
Ashish Kr.
I tried to use the example that you wrote, but this not work.
SOQL I tried to use:
SELECT Id, Name, Opportunity.Name FROM item_da_Oportunidade__c
The link that you share with me, only shown the Nested SOQL from Parent to Child.
Just try the below SOQL: Regards,
Ashish Kr.
I'm still getting an error
ERROR at Row:1:Column:18
Didn't understand relationship 'Opportunity__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.
You will have to replace the Opportunity__r with the field api name for example the api of the field is opp__c then use as opp__r.Name to get the opportunity name.
Hope this clears the thing.
Please let me know if it solves the problem.
Regards,
Ashish Kr.
Now I get it.
I have to use the custom field that make the relationship with my parent object, so then it will work.
As you say, my custom field is Oportunidade__c, so I use Oportunidade__r.Name and I could access the data of my parent object.
Thanks Ashish for your help.