Operation Details
Description: Returns a list of Case Events which match the caseID and date range
Sterotype: nsmulti
SQL 
SELECT
  caseEventID,
  caseID,
  relatedID,
  eventTypeCode,
  startDate,
  endDate,
  statusCode,
  recordStatus,
  versionNo
INTO
  :caseEventID,
  :caseID,
  :relatedID,
  :eventTypeCode,
  :startDate,
  :endDate,
  :statusCode,
  :recordStatus,
  :versionNo 
FROM
  CaseEvent 
WHERE CaseEvent.caseID = :caseID 
  AND 
  (
    
    (
      CaseEvent.startDate >= :fromDate 
      AND CaseEvent.startDate <= :toDate 
      OR CaseEvent.startDate < :fromDate 
      AND CaseEvent.endDate >= :toDate 
    ) 
  )