Salesforce Java script join or reference queries

Question

I am trying to select data from a couple objects at the same time using Javascript.

I want to select the LOB__C, risk_state__c FROM Opportunity and the Contact's firstname and lastname that is related to that Opportunity. I can't figure out how to do that.

Thanks guys.

How is the contact related to the opportunity? Contact Roles, custom relationship? — Jeremy Ross
– Jeremy Ross, Commented Apr 2, 2012 at 18:29
Hi Jeremy, I thought I had it related, but it wasn't. What would be be best practice? Should I query through the Account object or add a reference to Opportunity. Contact(parent) -> Opportunity(child). Still not sure how to create the query. Thanks for the help thus far. — Havoc783
– Havoc783, Commented Apr 2, 2012 at 18:38

Matt K · Accepted Answer · 2012-04-02 19:51:11Z

3

If you need to access a single Contact, you would need to add a reference field on the Opportunity to the Contact (using either a Lookup or Master-Detail relationship field).

From there, you can query like this:

Select LOB__c, risk_state__c, 
    Contact__c, Contact__r.FirstName, Contact__r.LastName From Opportunity

If you're looking at accessing all/multiple contacts for an Opportunity, store them in the OpportunityContactRole object and use a query like this:

Select LOB__c, risk_state__c,
    (Select ContactId, 
        FirstName, LastName From OpportunityContactRoles) From Opportunity

edited Apr 2, 2012 at 19:51

answered Apr 2, 2012 at 19:45

Matt K

7,3476 gold badges41 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Salesforce Java script join or reference queries

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related