我试图在一个对象上写一个查询,机会,这个对象有一个子对象引号。
在引号中有一个名为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)更多推荐
发布评论