# The query requires Id in the where clause: API Driver

**URL:** <https://community.cdata.com/t/the-query-requires-id-in-the-where-clause-api-driver/281>\
**Category:** Editions\
**Tags:** in-operator, article, api-driver\
**Created:** [July 24, 2023, 5:19pm UTC](https://community.cdata.com/t/the-query-requires-id-in-the-where-clause-api-driver/281 "2023-07-24T17:19:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Altin](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@Altin](https://community.cdata.com/u/Altin)\
**Post date:** [July 24, 2023, 5:19pm UTC](https://community.cdata.com/t/the-query-requires-id-in-the-where-clause-api-driver/281/1 "2023-07-24T17:19:14Z")

</div>

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.