AnsweredAssumed Answered

Querying Salesforce Accounts based on a custom field value in the Partner Account

Question asked by cathryn.crane207763 on Feb 7, 2018
Latest reply on Feb 14, 2018 by cathryn.crane207763

I need to pull all opp records where a field on the partner Account is blank.


In our Account object, we have 'Partner_Account__c' field which maps back to the Id field of the Account.


I have the Opp Id and I only need to pull it if field A on the Partner Account record is blank.  Does this make sense?


Can I write this in a SOQL statement?  I know that if you pull the Opportunity object, it pulls all related objects such as Account but in this case.  If this was in SQL, I would write a recursive query.