Articles in this section
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

  1. Create Dashboard Parameter:

  2. 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.
  3. 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.
      image.png

      image.png
  4. Save Data Source:

    • After configuring the parameters, save the data source and create the dashboard.
      image.png
  5. Publish and View Dashboard:

    • Once the dashboard is created, publish it and view it.
      image.png

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.
    image.png

Example URL Format

https://<servername>/dashboards/<dashboardid>/<category>/<dashboardname>?@<parameter1>=<value1>&&@<parameter2>=<value2>

Additional References

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
SM
Written by Soundarya Mani Meharan
Updated:
Comments (0)
Please  to leave a comment
Access denied
Access denied