Operation Details
Description: A list of unreserved task on a work queue @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.status,
  t.wdoSnapshot,
  t.overflowInd,
  deadlinetime AS dueDateTime
INTO
  :taskID,
  :priority,
  :status,
  :wdoSnapshot,
  :overflowInd,
  :dueDateTime 
FROM
  TaskWorkQueueAssignment,
  WorkQueue,
  Task t 
  
  LEFT OUTER JOIN
  
  WORKFLOWDEADLINE 
  ON WORKFLOWDEADLINE.taskID = t.taskID 
WHERE TaskWorkQueueAssignment.workQueueID = :workQueueID 
  AND t.taskID = TaskWorkQueueAssignment.taskID 
  AND WorkQueue.workQueueID = TaskWorkQueueAssignment.workQueueID 
  AND reservedBy IS NULL