Forum Discussion

SeanV's avatar
SeanV
New Contributor III
2 years ago

Get selected value from Combo Box and use it in a Table View

I have a dashboard that has 2 components,.

1. A Combo Box that is populated with a sql query in a Bound List Parameter.

2. A Spreadsheet that is populated with a Table View.   The table view is generated using a Spreadsheet Business Rule.

How do I pass the selection from the combo box to the table view?

 

Thank you for any suggestions.

Dashboards
Spreadsheet
  • SeanV's avatar
    SeanV
    2 years ago

    Thank you for the response.   

    I wasn't ablet to get BRApi.Dashboards.Parameters.GetLiteralParameterValue to pickup the parameter from the Combo Box.

     

    However I used  args.CustSubstVarsAlreadyResolved("parameterNameHere") and assigned that to a string variable.  That did work.  It got the parameter value from the combo box.

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    You should be able to grab the value in your Tableview rule with BRApi.Dashboards.Parameters.GetLiteralParameterValue. You should place the two components in separate Dashboard frames though, so you can refresh the one with the spreadsheet when the combobox value changes - otherwise it won't pick it up.

    • SeanV's avatar
      SeanV
      New Contributor III
      2 years ago

      Thank you for the response.   

      I wasn't ablet to get BRApi.Dashboards.Parameters.GetLiteralParameterValue to pickup the parameter from the Combo Box.

       

      However I used  args.CustSubstVarsAlreadyResolved("parameterNameHere") and assigned that to a string variable.  That did work.  It got the parameter value from the combo box.

      • Krishna's avatar
        Krishna
        Valued Contributor
        2 years ago

        Could you please provide the sample BR ? for the parameter from ComboBox ?