Database SQL Operation: EvidenceDescriptor.searchRelatedDescriptorIDByCorrSetStatuses
| Description: | Searches for evidence descriptor records by case id and correction set id which do not match a given evidence descriptor id and statuses. |
| Sterotype: | nsmulti |
SELECT
evidenceDescriptorID,
statusCode
INTO
:evidenceDescriptorID,
:statusCode
FROM
EvidenceDescriptor
WHERE
caseID = :caseID AND
correctionSetID = :correctionSetID AND
evidenceDescriptorID <> :evidenceDescriptorID AND
statusCode <> :statusCode1 AND
statusCode <> :statusCode2
|
