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

A sample URL link is included here for reference. 

http://single.qa.flowwright.com:8080/Dashboard/UserDashboard?dashboardID=b56678bf-ba49-427c-95d7-fe6df918112d&name=task&updBy=8161903A-80CC&status1=completed&status2=debug&varTimeZone=FLE

The parameters (or key-value pairs) are shown separately below. 

&name=task
&updBy=8161903A-80CC
&status1=completed
&status2=debug
&varTimeZone=FLE

To create a new dashboard, you must navigate to the Manage Config. - Dashboards menu option. 

The Manage Dashboard is rendered on a new page, as shown below. Click the Help icon for more information on the context. 

Select the Actions - Create menu option. A pop-up is displayed for configuration. Provide the dashboard name and the display order number. Select the checkbox 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 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 count(1) FROM [deDefinitions] where defName like '%variable.name%' and updatedBy like '%variable.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 '%variable.status1%' or status like '%variable.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 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 top 10 Left(deTaskAssignedTo,3), 'TotalTasksAssigned'=count(*)
  FROM [dbo].[deTasks]
  where deTaskStarted BETWEEN '01-Jan-2025' and '31-Aug-2025'
  and deTaskStatus like '%variable.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 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 top 10 'Name by alphabets'=upper(left(deExternalUserName,1)), 'Count'=count(*)
  from deUsers
  where timeZone like '%variable.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. 

http://single.qa.flowwright.com:8080/Dashboard/UserDashboard?dashboardID=b56678bf-ba49-427c-95d7-fe6df918112d&name=task&updBy=8161903A-80CC&status1=completed&status2=debug&varTimeZone=FLE

The dashboard is now rendered using the parameter values.