Panel Database Grid
The Database Grid dashboard panel is used to display the results of a pre-defined SQL query in a dashboard.
Grid Details
Besides the result list itself, the grid contains various controls that are specific to displaying the results.
-
If the Show Column Headers option is enabled, the column headers will be displayed. This also gives access to the data sorting and simple filtering capabilities of the interface.
-
If the Show Paging Toolbar option is enabled, the pagination controls will be visible and can be used to go through the results. Pagination controls include the following:
-
Back to Page 1
-
Back 1 Page
-
Page Selector
-
Items per Page Limiter
-
Forward 1 Page
-
Forward to Last Page
-
Refresh Results
-
Results Counter
-
Form Fields
-
Panel Name - Name of the panel to be displayed in the panel header.
-
Query - The pre-configured database query that will be used to select the data to be displayed, and can be configured on the Queries UI.
To open the Queries interface, from the main navigation menu, select Configuration, then Databases, and then Queries.
-
Tokens - If the selected query uses tokens, this property grid allows the query tokens to be linked to the values that will be passed into the query.
-
Show Column Headers - Whether or not to show the column headers, which grants access to the data sorting and simple filtering capabilities.
-
Show Paging Toolbar - Whether or not to show the toolbar, which contains pagination controls, the Refresh button and results counter.
-
Hide Header - Whether or not the panel header should be shown.
-
Width (%) - Limit the panel to a specific percent width of the dashboard, ranging from 10% to 100%.
-
Height (px) - Limit the panel to a specific height in pixels. "Auto" is checked by default. If unchecked, a field will be shown to enter a numerical value for the limit.
-
Paging Limit - The default pagination amount.