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

Hahaha, this is why before responding I should read the whole thing. They I've done that is to move the column from SQL editor back to a combobox and not keep it in the editor itself.

  • MarkBird's avatar
    MarkBird
    Contributor III
    2 years ago

    That won't work as the SQL table needs to hold multiple entities.

    Another thought that I had, is to have a popup dialog when you click new add new row, which allows you to choose the entity and store the selected entity in a literal parameter (and use the literal parameter in the Profit Centre filter). But not sure if that is possible?