The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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.
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
- JackLacava
OneStream Employee
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.
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.
Could you please provide the sample BR ? for the parameter from ComboBox ?
