Database SQL Operation: Screening.countByScreeningConfigOutside
Description: | Given a screening configuration ID and date range, determines how many screening have a start or end date that falls outside the start or end date provided, independent of case status. |
Sterotype: | ns |
SELECT
COUNT(*)
INTO
:count
FROM
Screening,
CaseHeader
WHERE Screening.screeningConfigID = :screeningConfigID
AND Screening.caseID = CaseHeader.caseID
AND
(
(
CaseHeader.startDate < :startDate
)
OR
(
CaseHeader.endDate > :endDate
)
)
|