Database SQL Operation: EvidenceDescriptor.searchDistinctEvidenceByTypeForCase
| Description: | Retrieves evidence instances based on the case id. An evidence instance represents one
evidence record for a group of evidence having a common succession id. |
| Sterotype: | nsmulti |
select correctionSetID, evidenceType, max(relatedID), max(versionNo)
INTO :correctionSetID, :evidenceType, :relatedID, :versionNo
from EVIDENCEDESCRIPTOR
WHERE CASEID=:caseID
AND EVIDENCETYPE=:evidenceType
AND (STATUSCODE = 'EDS1' OR STATUSCODE = 'EDS2' OR STATUSCODE = 'EDS4')
group by successionid, correctionSetID, evidenceType
|
