Operation Details
Description: @deprecated - replaced by {@link #searchAllActiveAndModifiedInstances()} @deprecated-since Version 6.0.5.1 Lists all the 'active', 'in edit', and 'identical in edit' evidence instances.
Sterotype: nsmulti
SQL
SELECT EVIDENCEDESCRIPTORID, SUCCESSIONID, EVIDENCETYPE, MAX ( RELATEDID ), PARTICIPANTID
INTO :evidenceDescriptorID, :successionID, :evidenceType, :evidenceID, :participantID
from EVIDENCEDESCRIPTOR 
WHERE CASEID=:caseID
AND (STATUSCODE = 'EDS1' OR STATUSCODE = 'EDS2' OR STATUSCODE = 'EDS2001')
GROUP BY SUCCESSIONID, PARTICIPANTID, EVIDENCETYPE, EVIDENCEDESCRIPTORID