Database SQL Operation: EvidenceDescriptor.searchDistinctEvidenceByParticipantIDAndTypeForCase
| Description: | This method retrieves evidence instances based on the participant id and 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 PARTICIPANTID=:participantID
AND (STATUSCODE = 'EDS1' OR STATUSCODE = 'EDS2' OR STATUSCODE = 'EDS4')
group by successionid, correctionSetID, evidenceType
|
