Operation Details |
Description: | Method to return all records for an organization from a specified date onwards. |
Sterotype: | nsmulti |
SQL |
SELECT orgCalendarID, organisationID, nonWorkingDate, nonWorkingDayType, reason INTO :orgCalendarID, :organisationID, :nonWorkingDate, :nonWorkingDayType, :reason FROM OrganisationCalendar WHERE organisationID = :organisationID AND nonWorkingDate >= :startDate AND nonWorkingDate <= :endDate ORDER BY nonWorkingDate |