Canned Query Viewer


Learn about the various components of the Pull Reports™ Canned Query Viewer client.

The Canned Query Viewer displays controls to interact with one <canned_query> to create an export result. The Canned Query Viewer is only applicable to <report> configurations which contain at least one <canned_query>.

The Canned Query Viewer has the following components:

Figure 1. The user interface components of the Canned Query Viewer
The user interface components of the Canned Query Viewer


The header displays the current <canned_query> name and the full screen button.

A. "All Reports" breadcrumb

The "All Reports" breadcrumb links to the Report Repository.

B. Report name

The <canned_query>'s name attribute.

C. Full Screen

Toggles the creator between normal and full screen mode.

Press the Full Screen button again or the Escape key to exit full screen mode.

Filters Panel

The Filters panel supports editing of filter parameters to be applied to the Export Report REST API export. The filter configuration is preset by the <canned_query> configuration, but the filter operator and value(s) may be adjusted to customize the export result.

A. Filter panel indicator

The Filters panel indicator reflects the number of filters applied to the Export Report REST API export as a superscript to the Filters label.

B. Apply Changes button

The Apply Changes button becomes active when a user changes a filter's operator or value. Click the button to apply the filter changes to the export result.

C. Filter(s)

Each filter configured by the <canned_query> is listed with appropriate operator and value controls.

Result Preview

The Results Preview displays a limited preview of the export results and contains controls to export the report to any export format.

A. View mode buttons

Toggles the Results Preview between table and map view. The View mode buttons are only available if the <report> may be exported to the geojson format.

The default view mode may be set via the viewMode <canned_query> attribute.

B. SQL dialog button

Displays the Structured Query Language (SQL) and query parameters to be used when creating the export result.

The SQL button is visible when the configuration property is true for the report and the current user is permitted to request the GET Export SQL endpoint.

C. Open in Creator button

Clicking the Open in Creator button opens the current export report configuration in the Ad Hoc Report Creator so as to further parameterize the export report. Use the browser's back button to return to the Canned Query Viewer.

D. Export format select and button

The export format select list displays the available export format parameter values. The Export button exports the full report to a new browser window in the chosen format.

The Export button turns red and becomes disabled if the total number of results exceeds the configured

E. Export URL dialog button

The export URL dialog button button reveals the Export Report REST API URL and HTTP parameters to be used when the Export button is clicked.

F. Pagination indicator and links

The pagination indicator and controls display the current page of export results with links to navigate to the previous and next page. The page size is 100 records.

The total number of results displays red if it exceeds the configured

G. Table cell header

Table cell headers are above adjacent columns within the same table. Re-position all columns under the header by dragging the table cell header to the left or right. Click the remove button to remove all columns under the header from the export results.

H. Column cell header

Column cell headers are above each column. Re-position a column by dragging the column cell header to the left or right.

I. Filter indicator

Column cell headers display a filter icon if the column is used within a filter.

J. Column cell header controls

Click the Column cell header remove button to remove the column from the export results. Click the Column cell header menu button to display additional controls for column sorting, filtering, and positioning.

K. Sort indicator

Column cell headers display an ascending or descending indicator if the respective sort is applied to the column.