# Populating Dropdown list using SQL Query

**URL:** <https://forum.inductiveautomation.com/t/populating-dropdown-list-using-sql-query/7856>\
**Category:** Ignition\
**Created:** [January 17, 2014, 12:48pm UTC](https://forum.inductiveautomation.com/t/populating-dropdown-list-using-sql-query/7856 "2014-01-17T12:48:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbrosius](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@dbrosius](https://forum.inductiveautomation.com/u/dbrosius)\
**Post date:** [January 17, 2014, 12:48pm UTC](https://forum.inductiveautomation.com/t/populating-dropdown-list-using-sql-query/7856/1 "2014-01-17T12:48:36Z")

</div>

I’m fairly new to ignition, and was trying to populate a dropdown lists’ dataset using a distinct strings from a column

SELECT DISTINCT Runtime\_Product  
FROM Runtime\_DB  
ORDER by Runtime\_Product

I turned off polling in the SQL Query, however when i go to select the string from the list it works once, makes the selection and will not dropdown after that to change the selection.

Any help would be appreciated.

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [January 17, 2014, 1:24pm UTC](https://forum.inductiveautomation.com/t/populating-dropdown-list-using-sql-query/7856/2 "2014-01-17T13:24:04Z")

</div>

I dont know your DB design but what you have is correct, the polling is the dataset updating and has nothing to do with actually selecting a value from the dropdown.

Just to verify, you can click the dropdown and it will dropdown once, after that it does not respond when you click it again?

---

<div class="post-metadata">

**Author:** ![dbrosius](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@dbrosius](https://forum.inductiveautomation.com/u/dbrosius)\
**Post date:** [January 17, 2014, 1:33pm UTC](https://forum.inductiveautomation.com/t/populating-dropdown-list-using-sql-query/7856/3 "2014-01-17T13:33:20Z")

</div>

I just realized I had a NULL value being pulled as one of the distinct values for the column. I updated the column values correctly and its working fine now.