Cisco Cisco E-Mail Manager Unity Integration Option Technical References
A-12
Template Design Guide Using InfoMaker for Cisco Unified ICM/Contact Center Enterprise & Hosted Editions, Release 8.0(1)
Appendix A Creating Sample Report Templates
Sample Historical Template
HandleTimeToHalf
d.
Note that the columns appear across the top of the tables.
Step 3
Specify the Retrieval Argument and Where clause as follows:
a.
From the InfoMaker toolbar, select Design > Retrieval Arguments.
b.
At the Specify Retrieval Arguments dialog box, enter these three retrieval arguments:
– list_of_persvc
with Type
Number array.
Click Add.
– start_date
with Type
DateTime
. Click Add.
– end_date
with Type
DateTime
–
Click OK.
Step 4
Create the Where clause as follows:
a.
Click the Where tab at the bottom of the Table Layout screen.
b.
Create this three-part Where clause:
•
for Column, select
Service.SkillTargetID
fom the drop-down list.
•
for Operator, select
in
from the drop-down list.
•
for Value, right click, select Arguments, and paste :
list_of_persvc.
c.
for Logical select
and
to add a second row.
d.
for Column, select
Service_Half_Hour,DateTime.
e.
for Operator, select
>.
f.
for Value, right click, select Arguments, and paste :
start_date.
g.
for Logical, select
and
to add a third row.
h.
for Column, select
Service_Half_Hour,DateTime
.
i.
for Operator, select
<=
.