Previous Topic: Dashboard Search ArchitectureNext Topic: Bubble Charts


Dashboard Search SQL

Dashboard searches (and drilldown and live data searches) are all run indirectly via the 'Pane' search which is installed as part of the core support for dashboards. The search to populate a pane must therefore conform to a standard calling sequence with parameters as follows:

datFrom

The start date for the search

datTo

The end date for the search

nTop

The number of results to be obtained (for example, top 10)

sCategory

Category information for the search. This is automatically populated for a drilldown search with the row identifier (column 1 value) from the selected item, allowing the drilldown search to obtain relevant results.

sSeries

Series information for the search. This is automatically populated for a drilldown search with the column identifier (column name) from the selected item, allowing the drilldown search to obtain relevant results.

idUser

The id of the user running the search

bDebug

A debug flag allowing debug information to be written when set to 1.

Column names are not predefined by the 'Pane' search as there can be a variable number of columns. The column names are taken directly from the search results when displaying in the dashboard. (External drilldown searches may use all of the search definition facilities for defining columns and results attributes.) The first column will be used to define the Category (x-axis) and subsequent columns are used to define data series.