Database SQL Operation: EvidenceDescriptor.searchAllActiveEvidenceInstances
| Description: | @deprecated - replaced by {@link #searchAllEvidenceInstancesByCaseAndStatus()}
@deprecated-since Version 6.0.5.1
Lists all the active evidence instances. |
| Sterotype: | nsmulti |
SELECT SUCCESSIONID, EVIDENCETYPE, MAX ( RELATEDID ), PARTICIPANTID
INTO :successionID, :evidenceType, :evidenceID, :participantID
from EVIDENCEDESCRIPTOR
WHERE CASEID=:caseID
AND STATUSCODE = :statusCode
GROUP BY SUCCESSIONID, PARTICIPANTID, EVIDENCETYPE
|
