Cisco Cisco IPCC Web Option Technical References
3-8
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
The columns appear as text boxes across the top of the tables.
Note
Although you can drag the column text boxes in the Select Painter to reposition them, doing so does not
change their order in the tabular report layout. To rearrange (and rename) columns, you must use the
Report Painter.
change their order in the tabular report layout. To rearrange (and rename) columns, you must use the
Report Painter.
The default sort order for data is Ascending (A to Z; 1 to 10). If this order is appropriate, then you have
completed this procedure and can create retrieval arguments. To sort any columns in descending order,
follow Step 2.
completed this procedure and can create retrieval arguments. To sort any columns in descending order,
follow Step 2.
Step 2
To change the default sort order for the data that appears in the column:
a.
Click in the left pane of the Sort Window.
b.
Locate the columns you want sorted in Descending order.
c.
Clear the checkbox next to Ascending.
Create the Retrieval Argument(s) for the SQL Statement
When WebView users generate a report, they are prompted to select retrieval arguments. For real-time
reports, they need to select the Item(s) they want included in the report. For historical reports, they need
to select Items and also a Date Range of start_ and end_dates.
reports, they need to select the Item(s) they want included in the report. For historical reports, they need
to select Items and also a Date Range of start_ and end_dates.
When you create a template, you need to define the following retrieval arguments in your SQL select
statement:
statement:
•
For all templates, you define an ID argument for the Items, with the data type
NumberArray
.
•
In addition, for historical templates only, you define
start_date
and
end_date
arguments, with
the data type
DateTime
.
These are the only arguments supported for WebView reports. Templates that do not include the correct
arguments will not appear in the template list in WebView.
arguments will not appear in the template list in WebView.
Follow these steps to create the retrieval argument:
Step 1
From the Select Painter menu, click Design > Retrieval Arguments to open the Specify Retrieval
Arguments dialog box.
Arguments dialog box.