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 |