Cisco Cisco IP Contact Center Release 4.6.1 User Guide
18
Cisco ICM Software Custom Screen Builder Guide
Chapter 3 Creating a New Report Template
Step 4: Create the SQL Statement
Note
InfoMaker allows you incorporate elements in SQL statements that are not
covered in this guide (e.g., Group Bys). For information on these additional
elements consult your InfoMaker documentation.
covered in this guide (e.g., Group Bys). For information on these additional
elements consult your InfoMaker documentation.
How to Select the Template Database Tables and Columns
To select the database tables and columns to use in your template:
1.
In the Select Tables dialog box, select one or more database tables whose data will
appear in the template.
appear in the template.
Note
For grid templates that will use WebView’s drill-down feature, make sure that
your table selection includes the configuration table for the template’s report
category. For example, Templates for the Peripheral Services category must
include the Service table. Templates for the Skill Group category must
include the Skill_Group table. For more information about the types of
templates that can use drill-down, see
your table selection includes the configuration table for the template’s report
category. For example, Templates for the Peripheral Services category must
include the Service table. Templates for the Skill Group category must
include the Skill_Group table. For more information about the types of
templates that can use drill-down, see
),
2.
Click Open. The tables you selected display in the SQL Select Painter window.
–
The SQL Select Painter consists of two sections: the Table Select window (upper),
and the SQL Toolbox window (lower).
and the SQL Toolbox window (lower).
–
To select additional tables, right-click in an empty area in the Table Select
window and choose Select Tables from the popup menu.
window and choose Select Tables from the popup menu.
–
To deselect a table, right-click on its title and choose Close from the popup menu.