# DropDown List Component SQL Query works in designer but not in Vision Client

**URL:** <https://forum.inductiveautomation.com/t/dropdown-list-component-sql-query-works-in-designer-but-not-in-vision-client/109710>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [August 13, 2025, 6:35pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-component-sql-query-works-in-designer-but-not-in-vision-client/109710 "2025-08-13T18:35:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![McLendon\_Automation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mclendon_automation/32/78325_2.png) [@McLendon\_Automation](https://forum.inductiveautomation.com/u/McLendon_Automation)\
**Post date:** [August 13, 2025, 6:35pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-component-sql-query-works-in-designer-but-not-in-vision-client/109710/1 "2025-08-13T18:35:27Z")

</div>

Using Ignition Version 8.1.48 and Vision Module Version 11.1.48

I created a Drop Down List and I am using it to sort data for a Vision Report.

The binding for this drop down list is a simple SQL query.

 ![Dropdown Data Binding query](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/5/45237e24ea8b3d77f167ad5912f2a694b6733054.png)

AS I said above, works as intended in the Designer. On the Vision Client this component is Red and has the Database issue icon.

 ![Dropdown Vision Error](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/6/c621b64ad1f93b6341cdd14b310610104d391e56.png)

Any and all help is appreciated. Thank you.

---

<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:** [August 13, 2025, 6:40pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-component-sql-query-works-in-designer-but-not-in-vision-client/109710/2 "2025-08-13T18:40:04Z")

</div>

Use a named query for Vision, for security.

If you must, enable legacy database permissions in the project properties.

---

<div class="post-metadata">

**Author:** ![McLendon\_Automation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mclendon_automation/32/78325_2.png) [@McLendon\_Automation](https://forum.inductiveautomation.com/u/McLendon_Automation)\
**Post date:** [August 13, 2025, 6:54pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-component-sql-query-works-in-designer-but-not-in-vision-client/109710/3 "2025-08-13T18:54:43Z")

</div>

Thank you pturmel. Using the Named Query allows this component to work as intended.

Out of curiosity, I just looked at the Gateway → Projects→ Selected this Project→ hit the Edit button

I don’t see any settings that is described as Legacy Database Permissions.

Am I looking in the wrong place to enable legacy database permissions?

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [August 13, 2025, 7:39pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-component-sql-query-works-in-designer-but-not-in-vision-client/109710/4 "2025-08-13T19:39:51Z")

</div>

These permissions are in the designer, not on the gateway.

> **[Project Properties | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/designer/project-properties)**
>
> There are a number of properties you can set for your projects within the Designer, Vision Clients, and Perspective Sessions. For example, there are properties for setting the touchscreen mode, customizing a client's auto-login, or configuring how...

> **[Vision Project Properties | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/vision/vision-project-properties#vision-permissions-properties)**
>
> There are a number of properties you can set for your Vision projects within the Designer. For example, there are properties for setting the Touch Screen mode, customizing a client's auto-login, or configuring how the clients receive updates, and...

---

<div class="post-metadata">

**Author:** ![McLendon\_Automation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mclendon_automation/32/78325_2.png) [@McLendon\_Automation](https://forum.inductiveautomation.com/u/McLendon_Automation)\
**Post date:** [August 13, 2025, 9:20pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-component-sql-query-works-in-designer-but-not-in-vision-client/109710/5 "2025-08-13T21:20:41Z")

</div>

Thank you ryan.white

For the next person who gets lost →

 ![Project Properties Location](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/2/928e21ac2ad1b11b18d5d0185c734ea8bed7383e.png)

 ![Project Properties Permisions](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/d/4d2a2839b634a513da01a078618e5205f6854bd6.png)

All of these were disabled when I first opened this window. I looked back on an old project and they were all selected so I selected them all for this project.