Cisco Cisco IP Contact Center Release 4.6.2 Technical References
3-12
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
View and Save a Completed SQL Statement
After completing your template’s SQL statement, you can review the entire statement by clicking the
Syntax tab in the Select Painter.
Syntax tab in the Select Painter.
Note
This is a read-only view of the SQL. To edit the SQL, click Design > Convert to Syntax.
An example of a completed SQL statement that includes a computed field (
AvgHandleTime
) and ID,
start_date, and end_date arguments:
SELECT Service.EnterpriseName,
Service_Half_Hour.DateTime,
Service_Half_Hour.CallsOfferedToHalf,
Service_Half_Hour.CallsHandledToHalf,
Service_Half_Hour.AvgDelayQToHalf,
Service_Half_Hour.HandleTimeToHalf,
Service_Half_Hour.ServiceLevelToHalf,
Service_Half_Hour.CallsAbandQToHalf,
Service_Half_Hour.DateTime,
Service_Half_Hour.CallsOfferedToHalf,
Service_Half_Hour.CallsHandledToHalf,
Service_Half_Hour.AvgDelayQToHalf,
Service_Half_Hour.HandleTimeToHalf,
Service_Half_Hour.ServiceLevelToHalf,
Service_Half_Hour.CallsAbandQToHalf,
AvgHandleTime=Service_Half_Hour.HandleTimeToHalf/Service_Half_Hour.
CallsHandledToHalf
CallsHandledToHalf
FROM Service, Service_Half_Hour
WHERE ( Service.SkillTargetID =
Service_Half_Hour.SkillTargetID ) and
( ( Service.SkillTargetID = :servicesList )
AND
( Service_Half_Hour.DateTime >= :start_date )
AND
( Service_Half_Hour.DateTime <= :end_date ) )
Service_Half_Hour.SkillTargetID ) and
( ( Service.SkillTargetID = :servicesList )
AND
( Service_Half_Hour.DateTime >= :start_date )
AND
( Service_Half_Hour.DateTime <= :end_date ) )
ORDER BY Service.EnterpriseName ASC,
Service_Half_Hour.DateTime DESC,
Service_Half_Hour.CallsOfferedToHalf ASC
Service_Half_Hour.DateTime DESC,
Service_Half_Hour.CallsOfferedToHalf ASC