Dropdown bind to SQL query, but allow no selection

Ignition
1

Using 7.9.10, I have a dropdown list bound to SQL query. This works fine. What if I want to deselect and have nothing selected? How can this be accomplished? Right now, the only available choices are what’s returned from the query, adding to the SQL table with a no solution value isn’t an option.

Any ideas?

1 Like
2

You could add a value to the query results without adding it into the database using something like

SELECT '-1', '<No Selection>'
UNION
<existing query>

The types from this added select need to match your current select.

Or you can add a button that sets the dropdowns selected value to -1.

3

Thanks Nick!