Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Tulasiram ChippalaTulasiram Chippala 

how to display opportunities which are related to a contact

I have Contact and Opportunity. How we can display related opportunities based on contact id. Any query any code. Please suggest me. 
Thank you!
Best Answer chosen by Tulasiram Chippala
Arunkumar RArunkumar R
Hi,

You can do like below,

List<OpportunityContactRole> oppContactRoles = new List<Opportunity>([SELECT Opportunity.Name, Opportunity.CloseDate FROM OpportunityContactRole WHERE ContactId = 'Contact Record ID']);

Reference:
https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_opportunitycontactrole.htm

All Answers

Arunkumar RArunkumar R
Hi, 

List<Opportunity> oppList = new List<Opportunity>([SELECT Id, Name FROM Opportunity WHERE Contact__c = 'Contact Record ID']);

Where Contact__c = Contact lookup field name from opportunity.
Tulasiram ChippalaTulasiram Chippala
Arunkumar can we do that using OpportunityContactRole. Because when we observe contact detail page has related list of opportunities
Arunkumar RArunkumar R
Hi,

You can do like below,

List<OpportunityContactRole> oppContactRoles = new List<Opportunity>([SELECT Opportunity.Name, Opportunity.CloseDate FROM OpportunityContactRole WHERE ContactId = 'Contact Record ID']);

Reference:
https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_opportunitycontactrole.htm
This was selected as the best answer
Tulasiram ChippalaTulasiram Chippala
Thanks @ArunKumar it worked
Tulasiram ChippalaTulasiram Chippala
i didn't seen that Arun. Now i selected your answer as best answer. Thank you!...