Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
2 years ago
Solved

Create a dependent dropdown list in SQL Table Editor

Hi,  Is it possible to create a dependent dropdown list using a SQL Table Editor? Example below: If I select Entity A in the Entity column, I would like PC1, PC2 to be options within the P...
Dashboards
Parameters
  • JackLacava's avatar
    JackLacava
    2 years ago

    No, that's not going to work. But you can hide that button and just create yours.

ckattookaran's avatar
ckattookaran
VIP
2 years ago
  • You can, I would suggest using a dashboard data set rule and then pass the parameter of the first drop down. Then in the rule check if the parameter is expanded. If it is then create a SQL to get the dependent ones and return the data table. On the dashboard side, you'll need those drops downs as a part of a different dashboard like a toolbar dashboard. On your anchor combobox, perform a refresh of the toolbar dashboard. There you go.