Dynamically Change Stored Procedure Parameter When a Grid Row is Clicked
To configure child grid widgets in a dashboard, it may be necessary to utilize stored procedure parameters and enable the ability to modify the parameter value by selecting a grid row. This can be accomplished by implementing a stored procedure URL filter with linking. The following is a comprehensive guide outlining the step-by-step process to achieve this.
Step 1: Configure Child Grid Widgets
First, configure N number of child grid widgets in a dashboard and bind the data with stored procedure data. Once you've done this, publish the dashboard.
Step 2: Create a New Dashboard
Next, create a new scratch dashboard and configure a parent grid widget.
Step 3: Bind the Data
Bind the data in the grid widget and enable "Linking" in the grid properties.
Step 4: Copy the Child Grid Dashboard Link
Copy the child grid dashboard link using the "GetLink" option and paste it into the grid widget Linking URL textbox in the parent dashboard.
Step 5: Add the Stored Procedure Parameter
Add the stored procedure parameter as a filter parameter in the link and select the target.
Step 6: Preview or Publish the Dashboard
Preview or publish the dashboard, and the context menu will open when clicking on the grid row.
Step 7: Select a Link Option
When selecting a link option in the context menu, the child grid dashboard will open accordingly.
By following these steps, you can successfully change the stored procedure value dynamically when a grid row is clicked.
Additional References
