Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
2 years ago

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
  • 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. 
Cosimo's avatar
Cosimo
Contributor II
2 years ago

If I read correctly, he would want the parameter list assigned to the Profit Centre field to update after making a selection in Entity field. I don't think it's possible as I'm not sure how making a selection in Entity field would invoke record level refresh of the STE component. Not sure how what you recommend would look like but now curious!!

  • MarkBird's avatar
    MarkBird
    Contributor III
    2 years ago

    Cosimo, that's exactly what I'm looking for