Comment:
Content imported from a Scroll Translations translation file.
...
Sv translation
language
de
Status
colour
Red
title
This page is only available in English
Sv translation
language
fr
Translations Ignore
Code Block
title
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;
Translations Ignore
Code Block
( AcdStatisticsPartB.ID IS NOT NULL ) AND ( AcdStatisticsPartB.AcdOriginGroupsID IS NULL )
Translations Ignore
Code Block
( AcdStatisticsPartB.dtQueueStart IS NOT NULL )
Translations Ignore
Code Block
( StatisticsPartA.dtCallConnect IS NOT NULL ) AND ( AcdStatisticsPartB.dtAgentConnect IS NOT NULL )
Translations Ignore
Code Block
( StatisticsPartA.dtCallConnect IS NOT NULL ) AND ( AcdStatisticsPartB.dtAgentConnect IS NULL )