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.
-
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.