Operation Details |
Description: | Reads details of activities 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 WHERE ( Activity.organisationID = :organisationID AND Activity.startDateTime < :endDateTime AND Activity.endDateTime >= :startDateTime ) |