Refresh tag history table

Ignition
2

SQL bindings will refresh if any referenced property or tag changes. So you could create a custom property on your dropdown called refresh (integer). If it is part of your SQL statement, then it will refresh if you just change the refresh value:

Your code to refresh the data:

#toggle between zero and one
rootContainer.getComponent("Dropdown").refresh += 1
rootContainer.getComponent("Dropdown").refresh %= 2

Dropdown.data:

SELECT fieldlist
FROM tableOrJoin
WHERE {Root Container.Dropdown.refresh}={Root Container.Dropdown.refresh}