# Perspective Dropdown SQL Query

**URL:** <https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query/41172>\
**Category:** Ignition\
**Tags:** perspective, scripting, ignition80\
**Created:** [December 3, 2020, 2:47pm UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query/41172 "2020-12-03T14:47:52Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [December 3, 2020, 3:02pm UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query/41172/2 "2020-12-03T15:02:11Z")

</div>

This was answered in the other thread. Use a script with runPrepQuery, generating SQL with a suitable number of ? substitutions. You can't just pass a tuple into a query. At least, not without massaging its string representation into something your SQL server will tolerate.

> [@Mouse Entered or Mouse moved events not working in Client](http://forum.inductiveautomation.com/t/mouse-entered-or-mouse-moved-events-not-working-in-client/41024/4):
>
> JDBC does not generally support passing a list as a single parameter. Using the IN operator generally requires the use of runPrepQuery where the appropriate number of question marks are placed inside the operator’s parenthesis, and the argument list constructed to match the number of question marks. Sorry.

---

_[View the full topic](https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query/41172)._