# Ignition Perspective Named Query with WHERE IN Clause

**URL:** <https://forum.inductiveautomation.com/t/ignition-perspective-named-query-with-where-in-clause/34062>\
**Category:** Ignition\
**Created:** [April 21, 2020, 1:33am UTC](https://forum.inductiveautomation.com/t/ignition-perspective-named-query-with-where-in-clause/34062 "2020-04-21T01:33:43Z")\
**Posts on this page:** 1\
**Showing post:** 8

<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:** [September 14, 2022, 6:17am UTC](https://forum.inductiveautomation.com/t/ignition-perspective-named-query-with-where-in-clause/34062/8 "2022-09-14T06:17:16Z")

</div>

This is really a question on a different topic unrelated to this thread. However …  
I think you are asking how to bind a multi-select dropdown ‘value’ to a session variable.

1. In the Project Browser, select _Perspective_.
2. In the Perspective Property Editor | Session Custom, add a new custom property of type Array. Call it `ddSelection` or whatever.
3. On your view, select the dropdown and in the Perspective Property Editor add a property binding on `props.value` to `session.custom.ddSelection` and make it bidirectional.

For debugging purposes add a label to the view, bind it to the session variable, turn on preview and you should see a list of selected values or `[]` when nothing is selected.

---

_[View the full topic](https://forum.inductiveautomation.com/t/ignition-perspective-named-query-with-where-in-clause/34062)._