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 |