There are cases when the profile, could support IN operator in the Where clause, so you can run a query like: Select * From <MyTable> Where <MyId> IN (Select Id from <otherTable>) or just simply: Select * From <MyTable> Where <MyId> IN (‘abc’, xyz)
Even though these queries are supported, you may still get this error: “The query requires <Id> in the where clause”.
In such cases, you need to set EnableLooseCriteriaEvaluation hidden property to “true” in the Other property, i.e.: Other= ‘EnableLooseCriteriaEvaluation=true’ to make it work.