Operation Details
Description: Reads details of activities for users for specified organization in specified dates range.
Sterotype: nsmulti
SQL 
SELECT
  activityID,
  subject,
  startDateTime,
  endDateTime,
  Activity.locationID,
  locationName,
  priorityCode,
  allDayInd,
  timeStatusCode,
  notes,
  recordStatusCode
INTO
  :activityID,
  :subject,
  :startDateTime,
  :endDateTime,
  :locationID,
  :locationName,
  :priorityCode,
  :allDayInd,
  :timeStatusCode,
  :notes,
  :recordStatusCode 
FROM
  Activity,
  Users 
WHERE 
  (
    Activity.userName = Users.userName 
    AND Activity.organisationID = :organisationID 
    AND Activity.startDateTime < :endDateTime 
    AND Activity.endDateTime >= :startDateTime 
  )