# Nested Query Dynamic Database

**URL:** <https://forum.inductiveautomation.com/t/nested-query-dynamic-database/62049>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 19, 2022, 8:32am UTC](https://forum.inductiveautomation.com/t/nested-query-dynamic-database/62049 "2022-07-19T08:32:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [July 19, 2022, 8:32am UTC](https://forum.inductiveautomation.com/t/nested-query-dynamic-database/62049/1 "2022-07-19T08:32:22Z")

</div>

Hi,

In my report module, I created a Nested Query. I would like to pass a database as parameter like below. It doesn’t work. Do you have a solution ?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/0/30e1947e3edd1dae3ab805536e70e6a9786af365.png)

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [July 19, 2022, 8:57am UTC](https://forum.inductiveautomation.com/t/nested-query-dynamic-database/62049/2 "2022-07-19T08:57:12Z")

</div>

Solved : Use a named query

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [July 19, 2022, 10:31am UTC](https://forum.inductiveautomation.com/t/nested-query-dynamic-database/62049/3 "2022-07-19T10:31:02Z")

</div>

Tip: please post code rather than pictures of code and format it using the \</\> button. It means people can copy the code to test it and paste it into their answers to edit it rather than typing the whole lot out again. Post a screengrab as well if it adds some important details.