Operation Details
Description: Returns a list of the task details for tasks that are assigned to a specified work queue, are reserved by a specified user and that are due within a specified time period. The status of the task may also be specified in the search criteria. This function returns the list of tasks ordered by task restart date time, earliest first. @deprecated Since Curam 6.0. The TaskWorkQueueAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment# searchReservedTasksDueInTheNextTimePeriodOrderByRestartDateTime( TasksByDueDateKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  t.taskID,
  t.priority,
  t.assignedDateTime,
  t.restartTime,
  t.wdoSnapshot,
  t.overflowInd,
  w.deadlineTime
INTO
  :taskID,
  :priority,
  :reservedDateTime,
  :restartDateTime,
  :wdoSnapshot,
  :overflowInd,
  :deadlineDateTime 
FROM
  Task t,
  WorkflowDeadline w,
  TaskWorkQueueAssignment twqa 
WHERE t.taskID = w.taskID 
  AND t.taskID = twqa.taskID 
  AND twqa.workQueueID = :workQueueID 
  AND w.deadlineTime >= :fromDeadlineDateTime 
  AND w.deadlineTime < :toDeadlineDateTime 
  AND t.reservedBy = :reservedBy 
  AND t.status = :status 
ORDER BY t.restartTime ASC