Salesforce SOQL查询以访问WHERE语句中的子字段(Salesforce SOQL Query to access a child field in WHERE statement)

Salesforce SOQL查询以访问WHERE语句中的子字段(Salesforce SOQL Query to access a child field in WHERE statement)

我试图在一个对象上写一个查询，机会，这个对象有一个子对象引号。

在引号中有一个名为Order_Ready的字段。

我需要做的是过滤所有批准报价的机会（Order_Ready__c == true）。

这是我一直试图开始工作的查询，

SELECT Id，Name（SELECT Order_Ready__c FROM Quotes）FROM Opportunity WHERE Opportunity.Quotes.Order_Ready__c = true

我尝试了一些这方面的变化，

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

我不得不承认，我不是SQL / SOQL最强的。 对我的错误或误解可能存在的任何见解？

谢谢！

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!

最满意答案

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