XIA Configuration Administrator's Guide

SQL Statement

All reports within XIA Configuration Server are written using the Microsoft Transact-SQL (TSQL) language with a small number of non-standard tokens described below. The SQL statement can be modified using the SQL Code Editor.

Allow the user to select a container or customer against which to run the report

Determines whether the user can select a container or customer against which to run the report. If this check box is enabled the [FILTERTOCONTAINER] token must be found within the WHERE clause of the SQL statement.

This displays the organization browser to the user when they execute the report.

Allow the user to sort the results

Determines whether the user can sort the results. If this check box is enabled the [SORTCOLUMN] token must be found as part of the ORDER BY clause of the SQL statement. When this option is enabled users can click the column headers of the report to sort by that column.

WARNING: Creating or modifying reports can expose information in the entire XIA Configuration Server database. Ensure that all custom reports are validated before being used in a production environment.