Cisco Cisco IPCC Web Option User Guide

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.

This guide assumes that you have a working knowledge of SQL and the ICM 
database.

ICM tables are described in-depth in the Database Schema Handbook for Cisco 
ICM/IPCC Enterprise & Hosted Editions . 

See 

 for details on what must be included in 

SQL statements for WebView reports.

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.)

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. 

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.

From the SQL Select text screen, make any modifications. For example, comment 
out parameters and add or remove columns.

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.