Cisco Cisco IP Contact Center Release 4.6.1 Technical References
3-9
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
Step 2
In the Name field, enter a name for the ID argument. The name cannot include spaces. Example:
skill_set_id.
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.
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.
not be able to see the template in WebView.
Step 4
Click OK to close the Specify Retrieval Arguments dialog box.
Construct the Where Clause for the SQL Statement
The Where clause limits data retrieval and acts as a placeholder for a value that the user will supply.
For example, if the retrieval argument specifies that the report is to return all rows from the Skill Group
table that match a user-supplied value, the Where clause looks similar like this:
table that match a user-supplied value, the Where clause looks similar like this:
WHERE:
SkillTargetID IN
(:
agtskg_list).
Follow these steps to specify the Where clause:
Step 1
Click the Where tab at the bottom of the Select Painter.
This tab displays initially as a table with four columns: Column, Operator, Value, and Logical.
Step 2
Click the Column field to open Column drop-down list. Then select the table column whose data will
be matched against your first retrieval argument.
be matched against your first retrieval argument.
Note
An ID argument must reference a specific database column based on report category.
lists the database columns to use with
each report category,
Step 3
Click the Operator field and select the operator you want from the drop-down.