Page History

SELECT (Various Aggregations) FROM JTELStats.StatisticsPartA a LEFT JOIN JTELStats.AcdStatisticsPartB acdb ON a.ID = acdb.StatisticsPartAID LEFT JOIN JTELStats.StatisticsPartB b ON acdb.ID = b.AcdStatisticsPartBID WHERE ( a.ClientsID = _ClientsID ) AND ( a.dtCallStart BETWEEN _Timeslice_Begin AND TIMESTAMPADD( MINUTE, 15, _Timeslice_Begin ) ) GROUP BY a.ID;

( AcdStatisticsPartB.ID IS NOT NULL ) AND ( AcdStatisticsPartB.AcdOriginGroupsID IS NULL )

( AcdStatisticsPartB.dtQueueStart IS NOT NULL )

( StatisticsPartA.dtCallConnect IS NOT NULL ) AND ( AcdStatisticsPartB.dtAgentConnect IS NOT NULL )

( StatisticsPartA.dtCallConnect IS NOT NULL ) AND ( AcdStatisticsPartB.dtAgentConnect IS NULL )

a.bCallerHangup = 0 --> System hangup (Reject) a.bCallerHangup <> 0 --> Caller hangup (Abandoned)

( StatisticsPartB.ID IS NOT NULL )