Cisco Cisco Unified Contact Center Enterprise 9.0(1) Guia Do Utilizador

After completing your template’s SQL statement, you can review the entire 
statement by clicking the Syntax tab in the Select Painter. 

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,   

AvgHandleTime=Service_Half_Hour.HandleTimeToHalf/Ser

vice_Half_Hour.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 ) )   

ORDER BY Service.EnterpriseName ASC,   

  Service_Half_Hour.DateTime DESC,   

  Service_Half_Hour.CallsOfferedToHalf ASC