Step-by-Step Guide to Multi-Select Grid View Actions
The Use Case:
You want to have your users be able to select multiple items from a Grid View on a dashboard and have those multiple selections drive an action. In other words, the ability for the users to select multiple items from a Grid View and have those selections passed to a Business Rule.
The Solution:
1. Create a Grid View and set the “Allow Multiselect” property to “True”.
2. Set the “Column Name for Bound Parameter” to the column name that will be used to pass the selections to your business rule. In this example, the selected PersonID column is passed to a business rule.
3. Create an input parameter. This parameter will be bound to the grid view and will contain the selected values from the grid view.
4. Set the Bound Parameter property of your Grid View to this parameter.
5. Create a button. This button will execute a Dashboard Extender Business Rule and will get the selected values from the grid view.
6. Notice in the name value pairs that are being passed to the dashboard extender that the parameter is enclosed in square brackets. The square brackets are important, otherwise the selected members that are passed as a comma delimited string will not be interpreted correctly.
7. In the Dashboard Extender, create a string that will hold the passed-in selections as a name value pair. In this example, nothing else happens in the business rule other than writing the selected values to the error log for demonstration purposes.
8. From the dashboard that contains the button and the grid view, select a couple of rows and click the button.
9. The selected PersonID values are then written to the error log.
Keep in mind that the business rule in this example is very basic for demonstration purposes. The sky is the limit as to what you can do with those values now that you have them in your business rule. In addition, this will also work for a SQL Table Editor.
Contact
MindStream Analytics
Want to learn more about OneStream Software? Please complete the form below and we’ll get back to you shortly.
