SOQL Query to get all partners of an opportunity

Question

Need help retrieving all the partners from an opportunity given its id. This is what I thought it be :

List<Opportunity> temp = [Select (Select Role from OpportunityPartners)
From Opportunity where id='12345567'];

Not working though...and not sure what's wrong either

Answer 1

Here is a script you may find useful to run through Execute Anonymous:

for (ChildRelationship relation : SObjectType.Opportunity.getChildRelationships())
{
    String name = relation.getRelationshipName();
    if (name != null && name.contains('Partner'))
        system.debug(name + ' (' + relation.getChildSObject() + ')');
}

This script yields three relationships:

AccountPartners (AccountPartner)
OpportunityPartnersFrom (OpportunityPartner)
Partners (Partner)

It seems to me you want door #2, which would make your query:

SELECT (SELECT Role FROM OpportunityPartnersFrom) FROM Opportunity

Answer 2

Change your query to:

List<Opportunity> temp = [Select (Select Role from OpportunityPartnersFrom)
From Opportunity where id='12345567'];

From the Opportunity context that's it's API Name

Answer 3

If you do not need any fields from the Opportunity then you can query the OpportunityPartners object directly:

List< OpportunityPartner > temp = [Select Role from OpportunityPartner
Where OpportunityID ='12345567'];

Otherwise you will need to use the correct API Name of the relationship

List<Opportunity> temp = [Select (Select Role from OpportunityPartnersFrom)
From Opportunity where id='12345567'];