This feature allows passing “key-value” pairs to the Dashboard via the URL, enabling dynamic content rendering when used with SQL commands. 

A sample URL is included here for reference. 

https://qa.flowwright.com:8443/Dashboard/UserDashboard?dashboardID=b56678bf-ba49-427c-95d7-fe6df918112d&name=CSR&updBy=35635c17-06b5-455b-a1e6-51507c1e971f&status1=completed&status2=debug&varTimeZone=FLE

The parameters (key-value pairs) are listed below. 

&name=CSR
&updBy=35635c17-06b5-455b-a1e6-51507c1e971f
&status1=completed
&status2=debug
&varTimeZone=FLE

To create a new dashboard, go to Manage > Dashboards. 

The Manage Dashboard opens on a new page, as shown below. Click the Help icon for more details on the context. 

Select Actions > Create. A configuration pop-up appears. Enter the dashboard name and the display order number. Check the box to open the designer, then click Create. 

On the Dashboard designer canvas, drag and drop a Custom Number Widget. Double-click the widget to configure its UI properties. Enter the title description. Select the DB connection from the drop-down list. Enter the SQL query with a parameter reference as shown below. Click the “Test Query” button to validate the syntax. A notification message appears in the top-right corner. Note: The reserved word ‘param’ facilitates mapping key-value pairs in the URL.

select count(1) FROM [deDefinitions] where defName like '%param.name%' and updatedBy like '%param.updBy%'

On the Dashboard designer canvas, drag and drop a Custom Pie Chart Widget. Double-click the widget to configure the UI properties. Enter the title description. Select the DB connection from the drop-down list. Enter the SQL query with a variable reference as shown below. Click the “Test Query” button to validate the syntax. A notification message appears in the top-right corner. 

select status, 'Status Count'=count(*)
from deInstances
where status like '%param.status1%' or status like '%param.status2%'
group by status
order by 1

On the Dashboard designer canvas, drag and drop a Custom Line Chart Widget. Double-click the widget to configure its UI properties. Enter the title and description. Select the database connection from the drop-down list. Provide the SQL query with a variable reference as shown below. Click the “Test Query” button to validate the syntax. A notification appears in the top-right corner. 

  SELECT top 10 Left(deTaskAssignedTo,3), 'TotalTasksAssigned'=count(*)
  FROM [dbo].[deTasks]
  where deTaskStarted BETWEEN '01-Jan-2025' and '31-Oct-2025'
  and deTaskStatus like '%param.status1%'
  group by deTaskAssignedTo
  order by 2 desc

On the Dashboard designer canvas, drag and drop a Custom Bar Chart Widget. Double-click the widget to configure its UI properties. Enter the title and description. Select the database connection from the drop-down list. Enter the SQL query with a variable reference as shown below. Click the “Test Query” button to validate the syntax. A notification appears in the top-right corner. 

select top 10 'Name by alphabets'=upper(left(deExternalUserName,1)), 'Count'=count(*) 
from [dbo].[deUsers] 
where timeZone like '%param.varTimeZone%' 
group by upper(left(deExternalUserName,1))

Save the dashboard definition. A confirmation message appears in the top-right corner. 

Select the UI > Preview menu option. The dashboard is rendered on a new page without passing any parameters.  

Append the “key-value” parameters to the dashboard URL shown above. 

https://qa.flowwright.com:8443/Dashboard/UserDashboard?dashboardID=b56678bf-ba49-427c-95d7-fe6df918112d&name=CSR&updBy=35635c17-06b5-455b-a1e6-51507c1e971f&status1=completed&status2=debug&varTimeZone=FLE

The dashboard is now rendered with the parameter values.