Select ID from CCCallHistoryItems
where
PhoneDevice_ID=:PhoneDevice_ID and
(((AlertedAt$DATE >= :TestDate) and (AlertedAt$DATE < (:TestDate+1))) or
((FinishedAt$DATE >= :TestDate) and (FinishedAt$DATE < (:TestDate+1))))
Order by AlertedAt$DATEGenerated by ABRA Software a.s. 27.10.2021 16:35:09