Operation Details |
Description: | |
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, TaskLink WHERE ( TaskLink.linkedID = :linkedID ) AND ( TaskLink.linkType = :linkType ) AND ( TaskLink.taskID = Task_wa.taskID ) AND ( ( Task_wa.status <> :taskStatus ) OR ( :taskStatus IS NULL ) ) ORDER BY Task_wa.taskID |