Cisco Cisco IPCC Web Option Technische Referenzen

Tables

Service

Service_Half_Hour

Table Columns

Service.EnterpriseName

Service_Half_Hour.DateTime

Service_Half_Hour.CallsOfferedToHalf

Service_Half_Hour.CallsAbandQToHalf

Service_Half_Hour.ServiceLevelToHalf

Service_Half_Hour.AvgDelayQToHalf

Service_Half_Hour.CallsHandledToHalf

Service_Half_Hour.HandleTimeToHalf

Retrieval Argument

Name: 

services_list 

Type: 

Number array

Name: 

start_date 

Type: 

DateTime

Name: 

end_date 

Type: 

DateTime

Where Clause

Create a three part Where clause with these attributes:
Column: 

Service.SkillTargetID 

Operator: IN

 

Value: (argument) 

:services list

AND
Column: Service_Half_Hour.DateTime

 

Operator: >=

 

Value: (argument) 

:start_date

AND
Column: Service_Half_Hour.DateTime

 

Operator: <=

 

Value: (argument)

 :end_date

Sort Order

Set the sort order so that records display first by 

Service.EnterpriseName 

in ascending order, and then by 

Service_Half_Hour.DateTime

 in descending order.