Třídová akce

Kód:

9

Tělo:

SELECT 
FIRST 1
(
SELECT Count(*) FROM Cccallsstatistics where (EVENT$DATE >= :DateFrom) and (EVENT$DATE < :DateTo) and (CallCenterID = :CallCenter) and (LocalPhoneNumber = :Phone)
) as Celkem,
(
SELECT Count(*) FROM Cccallsstatistics where (EVENT$DATE >= :DateFrom) and (EVENT$DATE < :DateTo) and (CallCenterID = :CallCenter) and (LocalPhoneNumber = :Phone) and (ACTIVESTART$DATE <> 0)
) as Celkem_Vyrizeno,
(
SELECT Count(*) FROM Cccallsstatistics where (EVENT$DATE >= :DateFrom) and (EVENT$DATE < :DateTo) and (CallCenterID = :CallCenter) and (LocalPhoneNumber = :Phone) and (ACTIVESTART$DATE = 0) and (ALERTSTART$DATE = 0)
) as Celkem_Odpadle,
(
SELECT Count(*) FROM Cccallsstatistics where (EVENT$DATE >= :DateFrom) and (EVENT$DATE < :DateTo) and (CallCenterID = :CallCenter) and (LocalPhoneNumber = :Phone) and (ACTIVESTART$DATE = 0) and (ALERTSTART$DATE <> 0)
) as Celkem_Nevyzvednute
FROM Cccallsstatistics

Generated by ABRA Software a.s. 27.10.2021 16:35:09