Cisco Cisco IP Contact Center Release 4.6.1 User Guide

3-9

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

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.

When you create a template, you need to define the following retrieval arguments
in your SQL select 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.

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.

Step 2

In the Name field, enter a name for the ID argument. The name cannot include
spaces. Example: skill_set_id.

Step 3

From the Type drop-down list, select NumberArray. If you are creating a real-time
template, go to Step 5.

If you are creating an historical report, click Add and create arguments for the
start_date and the end_date, using DateTime as the data type for both.

The order of the retrieval arguments is important. If you do not enter them in the
correct order, you will not be able to see the template in WebView.

Step 4

Click OK to close the Specify Retrieval Arguments dialog box.