Operation Details
Description: Searches for tasks by reserved by user and the due date.
Sterotype: nsmulti
SQL
SELECT
  Task_wa.taskID,
  Task_wa.reservedBy,
  Task_wa.subject,
  Task_wa.dueDateTime,
  Task_wa.priority,
  Task_wa.status,
  Task_wa.versionNo
INTO
  :taskID,
  :reservedBy,
  :subject,
  :dueDateTime,
  :priority,
  :status,
  :versionNo 
FROM
  Task_wa 
WHERE 
  (
    Task_wa.reservedBy = :reservedBy 
  ) 
  AND 
  (
    Task_wa.status <> :taskStatus 
  ) 
  AND 
  (
    Task_wa.dueDateTime <= :endDateTime 
  ) 
  AND 
  (
    Task_wa.dueDateTime >= :startDateTime 
  ) 
ORDER BY Task_wa.taskID