Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
3-7
Template Design Guide Using InfoMaker for Cisco Unified ICM/Contact Center Enterprise & Hosted Editions, Release 8.0(1)
Chapter 3 Creating New Custom Templates
Create the SQL Statement
Select Tables for the SQL Statement
Follow these steps to select Tables:
Step 1
Scroll through the Select Tables dialog box to locate and click each table you want for the report.
Step 2
Click Open.
The Table Select window now contains the tables you selected. InfoMaker automatically joins tables by
their key relationships.
their key relationships.
Step 3
To add additional tables, right-click anywhere on the Table Select window and click Select Tables. Then
repeat Steps 1 and 2.
repeat Steps 1 and 2.
Step 4
To remove a table, right-click its title and choose Close.
Select Columns for the SQL Statement
Follow these steps to select columns:
Step 1
From each table you add to the Table Layout view, locate and click the column(s) from which you want
data to be retrieved.
data to be retrieved.
To remove a column, simply deselect it in the table.