| Operation Details |  |
| Description: | To count the number of assessment configurations for a given ID - for example, to see if one exists. Counts all records NOT matching the passed status. |
| Sterotype: | ns |
| SQL | |
SELECT
COUNT(*)
INTO
:numberOfRecords
FROM
AssessmentConfiguration
WHERE assessmentConfigurationID = :assessmentConfigurationID
AND
(
status <> :status
OR :status IS NULL
)
|