Category / Section
How to Pass Parameter to Stored Procedures via Dashboard URLs?
Published:
There may be an requirement where you need to pass the value to a stored procedure via the dashboard URL. Bold BI supports this functionality, it is possible to pass parameter values to stored procedures through the dashboard URL. This process involves creating dashboard parameters and configuring them to work with the stored procedures.
Steps to Pass Parameters
-
Create Dashboard Parameter:
- First, create the required dashboard parameter and save it. For detailed instructions, refer to the Configuring Dashboard Parameters documentation.
- First, create the required dashboard parameter and save it. For detailed instructions, refer to the Configuring Dashboard Parameters documentation.
-
Add Stored Procedure:
- Drag and drop the necessary stored procedure into your dashboard. For guidance on connecting to stored procedures, see the Connecting to Stored Procedures documentation.
-
Configure Parameter:
- A popup will appear to configure the parameter. Choose the ‘parameter’ field from the dropdown and select the respective dashboard parameter. By default, this dashboard parameter value will be configured to the stored procedure.
- A popup will appear to configure the parameter. Choose the ‘parameter’ field from the dropdown and select the respective dashboard parameter. By default, this dashboard parameter value will be configured to the stored procedure.
-
Save Data Source:
- After configuring the parameters, save the data source and create the dashboard.
- After configuring the parameters, save the data source and create the dashboard.
-
Publish and View Dashboard:
- Once the dashboard is created, publish it and view it.
- Once the dashboard is created, publish it and view it.
Passing Parameters via URL
To pass parameters to the stored procedure via the dashboard URL, append your query string to the URL. Use the following format:
- If the URL does not already contain a query string, add a prefix
?
to the query string. - If the URL already contains a query string, add a prefix
&&
to the query string.
Example URL Format
https://<servername>/dashboards/<dashboardid>/<category>/<dashboardname>?@<parameter1>=<value1>&&@<parameter2>=<value2>