Skip to main content
Feb 8, 2023 9:25 PM UTC
Solved

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.

SeanVAnswer
Feb 9, 2023 6:27 PM UTC

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.

7 replies

Employee - Sage
Feb 9, 2023 8:24 AM UTC

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.

SeanVAuthorAnswer
Feb 9, 2023 6:27 PM UTC

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.

Expert
Feb 22, 2023 5:49 PM UTC

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