# prepQuery with WHERE IN() statement

**URL:** <https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359>\
**Category:** Ignition\
**Tags:** ignition81, scripting\
**Created:** [January 25, 2022, 3:37pm UTC](https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359 "2022-01-25T15:37:03Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 3, 2023, 3:19pm UTC](https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359/9 "2023-08-03T15:19:20Z")

</div>

Note that at least one JDBC driver tolerates a form of this through Ignition's "Prep" queries:

> [@Read/Write and Clear from an Array Tag (integer array)](https://forum.inductiveautomation.com/t/read-write-and-clear-from-an-array-tag-integer-array/74199/5):
>
> Does it work if you convert the list into a jarray first? v = [0,1,2,3] import jarray from java.lang import Integer v\_arr = jarray.array(v, Integer) To be honest I'm not even sure if array columns are supported or not, but see if this gets you to an error somewhere further.

---

_[View the full topic](https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359)._