You need to sign in to do that
Don't have an account?
sreeja
child- parent soql with the masterdetail relation ship
i have created a custom objects of contract__C (parent)and quotatin__C as(child), and created a masterdetail relation between them ..
i need to query the parent id as like :
contact = [select Id,name,accountid from contact where accountid=:selectedAccId];
i hve used :
quotation__c =[select id, name , contract__r.id form quotation__c where contract_r.id =: selectdContid];
how can i call this .. any suggestions
thanks
i need to query the parent id as like :
contact = [select Id,name,accountid from contact where accountid=:selectedAccId];
i hve used :
quotation__c =[select id, name , contract__r.id form quotation__c where contract_r.id =: selectdContid];
how can i call this .. any suggestions
thanks
Greetings to you!
Custom object child relationships end in __r. So the likely relationship name would be Contract__r. Your query is correct. You can check the field name (lookup or master-detail) by following below steps.
Go to Quotation object -> Fields and Relationships -> Contarct field
You can check your query by executing it in 'Open Execute Anonymous Window'.
Please refer to the below links which might help you further.
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships.htm
http://www.sfdc99.com/2013/06/09/example-how-to-write-a-cross-object-soql-query/
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
Thanks and Regards,
Khan Anas
You can get id of parent record from the child record from the following queries:
List<quotation__c> qList=[select id, name , contract__c from quotation__c where contract__c =: selectdContid];
OR
List<quotation__c> qList=[select id, name , contract_r.id from quotation__c where contract_r.id =: selectdContid];
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Deepali Kulshrestha