Cisco Cisco IP Contact Center Release 4.6.1 User Guide

In the Column drop-down list, select the table column whose data will be matched 
against your first retrieval argument. 

An ID argument must reference a specific database column based on its 
report category. 

 

lists the database columns to use with each report category, 

In the Operator drop-down list, select the operator you want to use. 

In the Value field, right-click and select Argument from the popup menu.

A dialog box opens displaying the list of defined arguments. Select the argument 
appropriate for your column.

As necessary, to add additional Where criteria, from the Logical drop-down list, 
select AND.

Because the DateTime intervals specified in the historical database represent 
the beginning of an interval.,Argument end date expressions must use <  (not 
<= ) as the operator, 

Example: A historical report might contain these elements:

Column: my_table.entityID
Operator: =
Value: :NumberArray

AND
Column: my_table.my_date
Operator: >=
Value: :start_date

AND

Column: my_table.my_date
Operator: <
Value: :end_date

Optionally, you can create computed columns that reflect calculations based on the 
values of two more database columns. You can create computed columns in both 
real-time and historical templates.

You can also create computed columns later in the template creation process when 
designing the template’s layout in the Report Painter.