Operation Details |
Description: | |
Sterotype: | nsmulti |
SQL |
SELECT Task_wa.taskID, Task_wa.subject, Task_wa.priority, Task_wa.status, Task_wa.dueDateTime, Task_wa.versionNo INTO :taskID, :subject, :priority, :status, :dueDateTime, :versionNo FROM Task_wa, TaskAssignment WHERE TaskAssignment.relatedName = :userName AND TaskAssignment.assigneeType = 'RL9' AND Task_wa.taskID = TaskAssignment.taskID AND reservedBy IS NULL |