Operation Details
Description: Retrieves details on all tasks the have been assigned to a work queue and have been 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# searchAllReservedTasksByRelatedIDAndType(TaskIDRelatedIDAndTypeKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  t.reservedBy,
  t.status,
  u.fullName
INTO
  :reservedBy,
  :status,
  :userFullName 
FROM
  TaskWorkQueueAssignment twqa,
  Task t 
  
  LEFT OUTER JOIN
  
  Users u 
  ON (t.reservedBy = u.userName) 
WHERE twqa.workQueueID = :workQueueID 
  AND t.taskID = twqa.taskID 
  AND t.reservedBy IS NOT NULL 
ORDER BY t.reservedBy