Operation Details
Description: nsmulti retrieval method to get Case Event details by Case ID, ordered by StartDate descending.
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 
  ) 
ORDER BY CaseEvent.startDate DESC