Operation Details
Description: Retrieves the details of the activities associated with a particular case and status.
Sterotype: nsmulti
SQL 
SELECT
  activityID,
  userName,
  organisationID,
  subject,
  activityTypeCode,
  startDateTime,
  endDateTime,
  allDayInd,
  locationID,
  locationName,
  priorityCode,
  timeStatusCode,
  notes,
  recurrenceID,
  caseID,
  concernRoleID,
  recordStatusCode
INTO
  :activityID,
  :userName,
  :organisationID,
  :subject,
  :activityTypeCode,
  :startDateTime,
  :endDateTime,
  :allDayInd,
  :locationID,
  :locationName,
  :priorityCode,
  :timeStatusCode,
  :notes,
  :recurrenceID,
  :caseID,
  :concernRoleID,
  :recordStatusCode 
FROM
  Activity 
WHERE 
  (
    Activity.caseID = :caseID 
    AND Activity.recordStatusCode = :recordStatusCode 
  ) 
ORDER BY Activity.startDateTime DESC