# Can't get SQL binding to work with dropdown in perspective

**URL:** <https://forum.inductiveautomation.com/t/cant-get-sql-binding-to-work-with-dropdown-in-perspective/87754>\
**Category:** General Discussion\
**Tags:** perspective\
**Created:** [March 22, 2024, 3:58pm UTC](https://forum.inductiveautomation.com/t/cant-get-sql-binding-to-work-with-dropdown-in-perspective/87754 "2024-03-22T15:58:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_Salisbury](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/thomas_salisbury/32/62046_2.png) [@Thomas\_Salisbury](https://forum.inductiveautomation.com/u/Thomas_Salisbury)\
**Post date:** [March 22, 2024, 3:58pm UTC](https://forum.inductiveautomation.com/t/cant-get-sql-binding-to-work-with-dropdown-in-perspective/87754/1 "2024-03-22T15:58:50Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/6/c6fa955e5d8ea72ddbe3818b004c92decf42cb05.png)  
I am working with a perspective window, and I can't seem to get the dropdown to work with the binding as attached. I can test the query just fine int he Named Queries

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 22, 2024, 4:32pm UTC](https://forum.inductiveautomation.com/t/cant-get-sql-binding-to-work-with-dropdown-in-perspective/87754/2 "2024-03-22T16:32:08Z")

</div>

If you're trying to pass the literal string `workorder` as the value for the parameter `type`, you need to wrap it in quotes.

The little _`fx`_ icon is indicating to you that the text you enter there is actually an expression. You can click that icon and get a popup expression helper. Most of the time, you'll be binding those parameters to other components or properties on your views, so expression mode is the default.

---

<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:** [March 22, 2024, 4:48pm UTC](https://forum.inductiveautomation.com/t/cant-get-sql-binding-to-work-with-dropdown-in-perspective/87754/3 "2024-03-22T16:48:45Z")

</div>

... and if you hover over the red Error\_Configuration error you will get an explanatory tooltip.

---

<div class="post-metadata">

**Author:** ![Thomas\_Salisbury](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/thomas_salisbury/32/62046_2.png) [@Thomas\_Salisbury](https://forum.inductiveautomation.com/u/Thomas_Salisbury)\
**Post date:** [March 22, 2024, 5:37pm UTC](https://forum.inductiveautomation.com/t/cant-get-sql-binding-to-work-with-dropdown-in-perspective/87754/4 "2024-03-22T17:37:19Z")

</div>

It wasn't very helpful.

---

<div class="post-metadata">

**Author:** ![Thomas\_Salisbury](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/thomas_salisbury/32/62046_2.png) [@Thomas\_Salisbury](https://forum.inductiveautomation.com/u/Thomas_Salisbury)\
**Post date:** [March 22, 2024, 5:37pm UTC](https://forum.inductiveautomation.com/t/cant-get-sql-binding-to-work-with-dropdown-in-perspective/87754/5 "2024-03-22T17:37:54Z")

</div>

Thank you. I figured it was something to do with that, but what I kept trying wasn't working