Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I'm trying to frame a single SOQL on opportunity with fields from Multiple objects like Account Name, Contact Name ,Contact Ph , Contact Email and the Opplineitems. I'm not sure how to get the Account Name and Contact Details from opp which has lookup.
Opportunity Op=[select id,Name,Stagename,Account__r.Name,(select Product_Name__c,Bid_Type__c from OpportunityLineItems) from opportunity where stagename='Closed-Won' and id=:opptyid];
Unless you have a contact related to the Opp via a lookup then you will have to do two queries. (or a subquery on via Contact Roles child object on Opp if that fits your need) For Account use
Account.name
From the query on Opp
Since you have a lookup to contact, use the API name replacing the __c with __r and add .name or whatever other field you need
__r; OOB SFDC fields never use__c. Hence relationship from Opportunity to Account is simplyaccount.someAccountOOBfieldnameoraccount.someAccountCustomfieldname__c– cropredy Aug 21 '15 at 19:40