Operation Details
Description: Returns specific details for all the reserved tasks that have been assigned to a work queue and that are due within the specified deadline due date. The details returned include the name of the user that has reserved the task, the status of the task and the full name of the user who has reserved the task. @deprecated Since Curam 6.0. The TaskWorkQueueAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment# searchAllReservedTasksByRelatedIDTypeDueInTheNextTimePeriod( TasksByDueDateKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  t.reservedBy,
  t.status,
  u.fullName
INTO
  :reservedBy,
  :status,
  :userFullName 
FROM
  TaskWorkQueueAssignment twqa,
  Users u,
  Task t 
  
  LEFT OUTER JOIN
  
  WorkflowDeadline w 
  ON (t.taskID = w.taskID) 
WHERE twqa.workQueueID = :workQueueID 
  AND w.deadlineTime >= :fromDeadlineDateTime 
  AND w.deadlineTime < :toDeadlineDateTime 
  AND t.taskID = twqa.taskID 
  AND t.reservedBy IS NOT NULL 
  AND t.reservedBy = u.userName 
ORDER BY t.reservedBy