Havoc783
Havoc783

Reputation: 157

Salesforce Java script join or reference queries

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.

Upvotes: 0

Views: 496

Answers (1)

Matt K
Matt K

Reputation: 7337

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

Upvotes: 3

Related Questions