Forum Discussion

Mike_Sabourin's avatar
Mike_Sabourin
Contributor II
14 days ago
Solved

Supplied parameter tied to Bound List not returning value

Hi community, I have an issue where i have a member list tied to a bound list. The bound list uses a SQL query to get the top member of a given dimension. I have this bound list tied to a supplied p...
Admin
Dashboards
Extenders
System
  • JackLacava's avatar
    JackLacava
    13 days ago

    This is a long-standing issue with the order of evaluation of parameters. Bound lists cannot have a default value, because the system does not know which value could be valid until it runs the sql - which will happen later in the loading process. Once the bound list actually runs and the parameter is set, it is cached, so at the next load it will be there from the start.

    What you can do is execute a dashboard extender during the dashboard load, which will set a value in the parameter (aka "custom substitution variable").

JackLacava's avatar
JackLacava
Community Manager
13 days ago

This is a long-standing issue with the order of evaluation of parameters. Bound lists cannot have a default value, because the system does not know which value could be valid until it runs the sql - which will happen later in the loading process. Once the bound list actually runs and the parameter is set, it is cached, so at the next load it will be there from the start.

What you can do is execute a dashboard extender during the dashboard load, which will set a value in the parameter (aka "custom substitution variable").

  • Mike_Sabourin's avatar
    Mike_Sabourin
    Contributor II
    13 days ago

    That's what I ended up doing, by incorporating the SQL into the load function and supplying it to the parameters. Not as elegant as I wanted, but it works now. Thanks

    • JackLacava's avatar
      JackLacava
      Community Manager
      13 days ago

      You can make it slightly more elegant by turning the SQL bound list into a Method one of type Business Rule, which runs a Dashboard DataSet that can share logic with the onload extender.