Operation Details |
Description: | Retrieves details on all tasks the have been assigned to a work queue but have yet to be reserved. @deprecated Since Curam 6.0. The TaskWorkQueueAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment# searchAllUnreservedTasksByWorkQueue(TaskIDRelatedIDAndTypeKey)}. See release note CR00223130. |
Sterotype: | nsmulti |
SQL |
SELECT t.taskID, t.priority, t.assignedDateTime, t.wdoSnapshot, t.overflowInd, w.deadlineTime INTO :taskID, :priority, :assignedDateTime, :wdoSnapshot, :overflowInd, :deadlineDateTime FROM TaskWorkQueueAssignment twqa, WorkQueue wq, Task t LEFT OUTER JOIN WorkflowDeadline w ON w.taskID = t.taskID WHERE twqa.workQueueID = :workQueueID AND t.taskID = twqa.taskID AND wq.workQueueID = twqa.workQueueID AND t.reservedBy IS NULL ORDER BY w.deadlineTime |