Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Where clause in subquery of openquery not working?

I am using open query and "WHERE" clause inside the subquery is not working. It is returning the results but they are not filtered based on "WHERE" clause. Here is the query I used:
select * from openquery(salesforce,
'SELECT Id, (Select Id, Status FROM Cases WHERE Status != ''Closed'') FROM Account
WHERE(Cancel_Date__c)
1 person has
this question
+1
Reply