<< Click to Display Table of Contents >> SQL Widgets |
SQL widgets display data from your PDQ Inventory SQL reports directly on the dashboard. Each SQL widget is tied to a specific report; when you add one you select which report to use.
SQL reports are created and managed in the Reports section of PDQ Inventory. Any report that returns data in the appropriate format can be used as the source for a SQL widget.
To add a SQL widget:
1.Enter edit mode by clicking the Edit Dashboard button (pencil icon).
2.Click the Add Widget button (+ icon) and select the SQL widget type you want.
3.In the widget library panel, select the report to use as the data source.
4.Optionally, give the widget a custom title.
5.Click Add to Dashboard.
Displays a single numeric value from a SQL report. The report must return at least one row with one column; the widget displays the value from the first row and first column.
Displays multiple label/value pairs from a SQL report. The report must return two columns: a label column and a value column. Each row appears as a separate metric in the widget.
Displays the full results of a SQL report in a scrollable data grid. Columns are derived from the report's result set.
Renders a bar chart from a SQL report. The report must return two columns: a category column (labels for each bar) and a value column (bar heights).
Renders a pie chart from a SQL report. The report must return two columns: a category column (slice labels) and a value column (slice sizes).
Renders a line graph from a SQL report. The report must return two columns: a time or sequence column (X axis) and a value column (Y axis).
© 2026 PDQ.com Corporation. All rights reserved.
PDQ.com is a trademark of PDQ.com Corporation. All other product and company names are the property of their respective owners.
Help Version: 20.1.14.0