Salesforce SOQL Query to access a child field in WHERE statement

Question

I am attempting to write a query on an object, Opportunity, this object has a child object Quotes.

In Quotes where have a field named, Order_Ready.

What I need to do is filter in all opportunities that have approved quotes (Order_Ready__c == true).

Here is the query I have been attempting to get working,

SELECT Id, Name (SELECT Order_Ready__c FROM Quotes) FROM Opportunity WHERE Opportunity.Quotes.Order_Ready__c = true

I have tried a few variations of this,

SELECT Id, Name (SELECT Order_Ready__c FROM Quotes) FROM Opportunity WHERE Quotes.Order_Ready__c = true

SELECT Id, Name (SELECT Order_Ready__c FROM Quotes) FROM Opportunity WHERE Order_Ready__c = true

I have to admit, I'm not the strongest with SQL/SOQL. Any insight into where my mistake or misunderstanding might be?

Thanks!

Are you using the standard Quote object? – Jeremy Ross Nov 30 '11 at 16:19 — Jeremy Ross, Nov 30 '11 at 16:19
Standard Opportunity object with a child Quotes – Bryan Harrington Nov 30 '11 at 16:56 — Bryan Harrington, Nov 30 '11 at 16:56
Ok, I updated my answer. – Jeremy Ross Nov 30 '11 at 17:16 — Jeremy Ross, Nov 30 '11 at 17:16

Jeremy Ross · Accepted Answer · 2011-11-30T17:15:50.900

4

SELECT Id, Name FROM Opportunity WHERE Id IN 
(Select OpportunityId FROM Quote WHERE Order_Ready__c = true)

edited Nov 30 '11 at 17:15

answered Nov 30 '11 at 16:10

Jeremy Ross

Thanks a bunch! When I performed a Google search on accessing Child Object fields in the WHERE clause I stumbled on this (although modified for my purpose), SELECT Id, Name (SELECT Order_Ready__c FROM Quotes) FROM Opportunity WHERE Opportunity.Quotes.Order_Ready__c = true, While Force Explorer doesn't not like this, Under what scenario would this work? The logic **seems** correct from the examples I found. – Bryan Harrington Nov 30 '11 at 22:25

1 Answers1