Cisco Cisco E-Mail Manager Unity Integration Option Guida Utente
3-11
Template Design Guide Using InfoMaker for Cisco ICM/IPCC Enterprise & Hosted Editions, Release 7.0(0)
Chapter 3 Creating New Custom Templates
Create the SQL Statement
Step 4
Right-click the Value field.
a.
Select Argument from the popup menu. This opens a dialog box displaying
the list of defined arguments.
the list of defined arguments.
b.
Select the argument appropriate for your column. Then click Paste.
Step 5
As necessary, to add additional Where criteria for the start and end dates, click the
Logical drop-down list and select AND.
Logical drop-down list and select AND.
, for an example of a
Where clause with start_date and end_date arguments.
Note
You can further narrow the scope of the report by adding additional Where
criteria that do not use arguments.
criteria that do not use arguments.
Create a Computed Column for the SQL Statement
You can create computed columns in both real-time and historical templates to
reflect calculations based on the values of two or more database columns.
reflect calculations based on the values of two or more database columns.
Note
You can also insert computed fields when you design the layout in the Report
Painter. However, computed fields created in the Report Painter do not support
WebView’s threshold capabilities or dynamic sorting. Computed columns created
in the SQL Select Painter do.
Painter. However, computed fields created in the Report Painter do not support
WebView’s threshold capabilities or dynamic sorting. Computed columns created
in the SQL Select Painter do.
It is best to create computed columns in the SQL Select Painter and to use the
Report Painter to modify their formatting, if necessary—for example, by
changing the format of the query result from seconds to minutes.
Report Painter to modify their formatting, if necessary—for example, by
changing the format of the query result from seconds to minutes.
Step 1
Locate the Compute tab at the bottom of the Select Painter. This tab initially
displays as a blank field.
displays as a blank field.