The SQL Card Widget displays SQL-based information in a card-style format.

Navigate to the Manage > Dashboards page. 

Click the Actions > Create menu option on the Manage Dashboard page to create a new dashboard. Provide the dashboard name and display order number. 

The dashboard designer canvas opens on a new page. Drag the SQL Card widget from the toolbox onto the designer canvas. Click the Edit icon to configure it. 

The Configure Widget UI properties are shown in the pop-up window below. Enter the title. Choose the database connection from the drop-down list. Provide the correct SQL SELECT syntax for the SQL Grouping chart algorithm. Use the $dateFilter (wildcard syntax) in the WHERE clause and reference an appropriate date column. Click the “Test Query” button to validate the SQL SELECT syntax. Note: On the Manage Dashboard page, go to the Utils - Date Filter On/Off menu to toggle the date filter for this dashboard definition. 

Select the card template by navigating the carousel left or right. 

You have 4 card templates to choose from; the card styles are listed below for reference. You can customize the “card title or label, primary value, and icon”.

Click a card style to select it, then click OK in the pop-up window to confirm the selection. 

Next, click the “Dashboard or Common” button to select the image files. Click the “Choose Files” button to browse and locate the file. You may upload multiple image files at once. Select a single image file, then click the “Select” button to confirm.   

Enter the text in the relevant fields shown in the image below. These fields vary by the card style selected. 

On the dashboard designer canvas, choose the UI > Preview menu to view the dashboard. 

The SQL Card widget dashboard appears on the new page. 

To view the dashboard in the menu pane, select Utils > Show/Hide on the dashboard designer canvas. 

Refresh the FlowWright Dashboard page to see the updated dashboard in the left pane, as shown below.