Database SQL Operation: EvidenceEffectivePeriod.searchNonCurrentEffectiveEvidenceOnDateLimitedToTwentyRows
Description: | Read all effective evidence periods for a given non active evidence record. Limited to 20 rows.
|
Sterotype: | nsmulti |
SELECT ED.evidenceDescriptorID, ED.relatedID, ED.evidenceType, EFP.fromDate, EFP.toDate INTO :evidenceDescriptorID, :relatedID, :evidenceType, :fromDate, :toDate FROM EVIDENCEDESCRIPTOR ED, EVIDENCEEFFECTIVEPERIOD EFP WHERE ED.CASEID= :caseID AND ED.EVIDENCEDESCRIPTORID= EFP.EVIDENCEDESCRIPTORID AND ED.EVIDENCETYPE= :evidenceType AND ED.STATUSCODE= :statusCode AND( EFP.TODATE IS NOT NULL AND EFP.TODATE < :effectivePeriodDate ) ORDER BY EFP.TODATE DESC
|