# Filtering table from multiselection dropdown

**URL:** <https://forum.inductiveautomation.com/t/filtering-table-from-multiselection-dropdown/91859>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 14, 2024, 10:45am UTC](https://forum.inductiveautomation.com/t/filtering-table-from-multiselection-dropdown/91859 "2024-06-14T10:45:57Z")\
**Posts on this page:** 1\
**Showing post:** 8

<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:** [July 23, 2024, 11:16am UTC](https://forum.inductiveautomation.com/t/filtering-table-from-multiselection-dropdown/91859/8 "2024-07-23T11:16:33Z")

</div>

You cannot pass lists into single JDBC parameters.

If you script your query with `runPrepQuery` instead of using a named query, you can dynamically generate question mark placeholders for all of the list elements, then pass the correct length argument list.

---

_[View the full topic](https://forum.inductiveautomation.com/t/filtering-table-from-multiselection-dropdown/91859)._