Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
DaveGCDaveGC 

Help with SOQL query for custom related object

Hello, I'm trying to figure out how to query a custom object that is related to opportunities. 

The object name is McaApp__Offer__c 
The lookup field for that object is McaApp__Opportunity__c (master-detail)

This is what I have, but I'mk missing something as this object is not related to accounts, what do I need to change?
  
SELECT id, Name, 
  ( 
    Select Id, Name From Opportunities ORDER BY Id DESC LIMIT 1 
  ), 
  ( 
    SELECT McaApp__Funder__c, McaApp__Status__c FROM McaApp__Offers__r WHERE McaApp__Opportunity__c = 'xxx' 
  )   
FROM Account 
WHERE id = 'xxx'

Thanks!