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
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. 
  • 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