# Dropdown using datatable working in preview but not in the client

**URL:** <https://forum.inductiveautomation.com/t/dropdown-using-datatable-working-in-preview-but-not-in-the-client/44527>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [March 16, 2021, 2:59pm UTC](https://forum.inductiveautomation.com/t/dropdown-using-datatable-working-in-preview-but-not-in-the-client/44527 "2021-03-16T14:59:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\
**Post date:** [March 16, 2021, 2:59pm UTC](https://forum.inductiveautomation.com/t/dropdown-using-datatable-working-in-preview-but-not-in-the-client/44527/1 "2021-03-16T14:59:00Z")

</div>

I am trying to use a query in the Data for a dropdown to extract a column to display as a list then write to a client tag. It works perfectly in the preview but does not display the list in the client while running. The dropdown is also mad at me and is red as it can get in these situations but with no information for me to troubleshoot.

Here is the query:  
SELECT Technician  
FROM WO\_MaintenanceTimeLogging  
order by Technician asc

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [March 16, 2021, 3:05pm UTC](https://forum.inductiveautomation.com/t/dropdown-using-datatable-working-in-preview-but-not-in-the-client/44527/2 "2021-03-16T15:05:05Z")

</div>

The query looks fine, which suggests something else is amiss.

1. How do you have the binding on the dropdown configured?
2. There should also be an icon with the ‘red’ overlay which signals why the overlay is active, what is it?
3. Are you designing on the same machine as the gateway?
4. Is the client running on the same machine as the designer?

---

<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:** [March 16, 2021, 3:45pm UTC](https://forum.inductiveautomation.com/t/dropdown-using-datatable-working-in-preview-but-not-in-the-client/44527/3 "2021-03-16T15:45:17Z")

</div>

That’s almost certainly having Legacy Query security permissions turned off in the project properties.

---

<div class="post-metadata">

**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\
**Post date:** [March 17, 2021, 11:31am UTC](https://forum.inductiveautomation.com/t/dropdown-using-datatable-working-in-preview-but-not-in-the-client/44527/4 "2021-03-17T11:31:44Z")

</div>

That was the solution thanks. I have never had to do this type of dropdown before so it was a learning experience.

---

<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:** [March 17, 2021, 1:31pm UTC](https://forum.inductiveautomation.com/t/dropdown-using-datatable-working-in-preview-but-not-in-the-client/44527/5 "2021-03-17T13:31:03Z")

</div>

Consider converting all such queries to named queries so you can leave that security permission turned off. It defaults to “off” for good reason.