# Do Lenses Kafka Connectors support the WHERE clause in kcql?

**URL:** <https://ask.lenses.io/t/do-lenses-kafka-connectors-support-the-where-clause-in-kcql/132>\
**Category:** Apache Kafka Connectors\
**Created:** [November 22, 2023, 12:56pm UTC](https://ask.lenses.io/t/do-lenses-kafka-connectors-support-the-where-clause-in-kcql/132 "2023-11-22T12:56:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Asaf\_Gur\_arie](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/asaf_gur_arie/32/71_2.png) [@Asaf\_Gur\_arie](https://ask.lenses.io/u/Asaf_Gur_arie)\
**Post date:** [November 22, 2023, 12:56pm UTC](https://ask.lenses.io/t/do-lenses-kafka-connectors-support-the-where-clause-in-kcql/132/1 "2023-11-22T12:56:45Z")

</div>

can i add where clause on kcql query?

---

<div class="post-metadata">

**Author:** ![grudtnerv](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/grudtnerv/32/101_2.png) [@grudtnerv](https://ask.lenses.io/u/grudtnerv)\
**Post date:** [December 5, 2023, 6:25pm UTC](https://ask.lenses.io/t/do-lenses-kafka-connectors-support-the-where-clause-in-kcql/132/2 "2023-12-05T18:25:49Z")

</div>

Hello Asaf\_Gur\_arie,

The WHERE statement isn’t supported by KCQL.