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

A sample URL link 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 shown 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 appears on a new page, as shown below. Click the Help icon for more details on the context. 

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

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 the mapping of key-values 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. Provide the title description. Select the DB 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 message is displayed 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 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 message 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 the UI properties. Provide 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 message 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 is displayed in the top-right corner. 

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

Append the above dashboard URL with the “key-value” parameters as shown below. 

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 using the parameter values.