Cisco Cisco IP Contact Center Release 4.6.1 User Guide
Chapter 3 Creating New Custom Templates
Create the SQL Statement
3-10
Template Design Guide Using InfoMaker for Cisco ICM/IPCC Enterprise & Hosted Editions, Release 7.0(0)
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.
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:
from the Skill Group 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.
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.
column whose data will be matched against your first retrieval argument.
Note
An ID argument must reference a specific database column based on
report category.
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.