Skip to content

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.

    Configuration -> Databases -> 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 0.01 to 1.

  • Auto Height - Whether or not the panel should automatically increase in height to show all data available.

  • Height - If Auto Height is not checked, limit the panel to a specific height in pixels.

  • Paging Limit - The default pagination amount.

Back