Retrieving Contact.Email, Opportunity.Name and OpportunityLineItem.Quantity in one query

Question

I'm trying to retrieve Contact.Email, Opportunity.Name and OpportunityLineItem.Quantity in a single SOQL query. Is this possible? If so, how?

My query is:

Select Opportunity.Id, Opportunity.Name, Contact.Email, (Select Quantity From OpportunityLineItem) From OpportunityContactRole Limit 10

My main objective is to get elements from OpportunityContactRole and OpportunityLineItem in a single query.

score 3 · Accepted Answer · answered Jan 07 '14 at 18:49

3

You were close :)

SELECT Id, Name,
    (SELECT Quantity FROM OpportunityLineItems),
    (SELECT Contact.Email FROM OpportunityContactRoles)
FROM Opportunity

answered Jan 07 '14 at 18:49

eyescream

score 0 · Answer 2 · answered Oct 16 '17 at 21:05

0

You can try something like:

SELECT Opportunity.Name, Contact.Email, Contact.Id FROM OpportunityContactRole WHERE Opportunity.Id = '<OppId>'LIMIT 1

answered Oct 16 '17 at 21:05

Matias

2 Answers2