Populating Dropdown list using SQL Query

Ignition
1

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.

2

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?

3

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.