# Can a NamedQuery be embedded in another NamedQuery?

**URL:** <https://forum.inductiveautomation.com/t/can-a-namedquery-be-embedded-in-another-namedquery/77371>\
**Category:** Ignition\
**Tags:** namedqueries\
**Created:** [August 3, 2023, 2:46pm UTC](https://forum.inductiveautomation.com/t/can-a-namedquery-be-embedded-in-another-namedquery/77371 "2023-08-03T14:46:19Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:18pm UTC](https://forum.inductiveautomation.com/t/can-a-namedquery-be-embedded-in-another-namedquery/77371/6 "2023-08-03T15:18:08Z")

</div>

> [@stan.cook](#):
>
> parameter data type option what would take a list of integers

Strictly speaking, this is not supported by generic JDBC, and therefore there is nothing in the named query system to accommodate them.

It so happens that at least one JDBC driver (PostgreSQL) will accept true java **arrays** (not _lists_) in single parameters, and Ignition's "Prep" queries will pass these correctly.

See this topic:

> [@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.

{ Perhaps we need a feature request for NQs to offer **array** parameters. }

---

_[View the full topic](https://forum.inductiveautomation.com/t/can-a-namedquery-be-embedded-in-another-namedquery/77371)._