Skip to main content
S
SeanV
February 8, 2023
Solved

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

  • February 8, 2023
  • 1 reply
  • 0 views

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.

    Best answer by SeanV

    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.

    1 reply

    J
    JackLacava
    February 9, 2023

    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.

    S
    SeanVAuthorAnswer
    February 9, 2023

    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.

    K
    Krishna
    February 22, 2023

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

    Terms & ConditionsAccessibility statement