Cisco Cisco IP Contact Center Release 4.6.2 Technical References
4-5
Template Design Guide Using InfoMaker for Cisco Unified ICM/Contact Center Enterprise & Hosted Editions, Release 8.0(1)
Chapter 4 Creating Custom Templates Based on Existing Templates
Make SQL Modifications.
Make SQL Modifications.
One of your goals might be to customize a standard report by changing its SQL statement.
To do this, you can work directly in InfoMaker, or you can copy the SQL statement from InfoMaker and
work in another tool, such as SQL Query Analyzer.
work in another tool, such as SQL Query Analyzer.
This guide assumes that you have a working knowledge of SQL and the Unified ICM database.
Unified ICM tables are described in-depth in the Database Schema Handbook for Cisco ICM/IPCC
Enterprise & Hosted Editions .
Enterprise & Hosted Editions .
See
for details on what must be included in SQL statements for
WebView reports.
To Modify the SQL
Step 1
Select Design > Data Source from the Report Painter menu to open the SQL Select statement. (To return
to the Report Painter from the SQL Select statement, click Return.)
to the Report Painter from the SQL Select statement, click Return.)
Note
The Select Painter allows you to create basic queries, but it does not support sophisticated
queries. For this reason, the graphical Select Painter is not available for most of the standard
WebView templates.
queries. For this reason, the graphical Select Painter is not available for most of the standard
WebView templates.
When you attempt to view the SQL Select Painter (by clicking Design > Convert to Graphics),
you are likely to see a message asking if you want to continue to Graphics mode. Click No to
open the SQL in text format.
Step 2
From the SQL Select text screen, make any modifications. For example, comment out parameters and
add or remove columns.
add or remove columns.
Step 3
Review the SQL and correct errors before you return to the Report Painter.
If necessary, copy the SQL to a different tool, such as the SQL Query Analyzer, to troubleshoot further.
Step 4
When the SQL is complete, click Return to review the changes in Report Painter.
•
Computed fields that are no longer valid are commented out.
•
Fields that are no longer in your result set are deleted.
•
New fields appear to the far right of the detail band.
Step 5
Select File > Save from the InfoMaker menu to save your work.
Make Design Modifications
After you modify the SQL statement, review the template in the Report Painter and make any design
modifications.
modifications.
For example, you might need to change headers, to delete or add columns, or to complete summaries.
Refer to the InfoMaker documentation for complete details on report layout.
See Chapter 5 of this guide for basic guidelines on template design.