| Operation Details |  |
| Description: | To count the number of cases for a given ID - for example, to see if a case exists. Ignores cases matching the passed status (for example, closed) |
| Sterotype: | ns |
| SQL | |
SELECT
COUNT(*)
INTO
:numberOfRecords
FROM
CaseHeader
WHERE caseID = :caseID
AND
(
statusCode <> :statusCode
OR :statusCode IS NULL
)
|