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 assigned 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# searchReservedTasksDueInTheNextTimePeriodOrderByReservedDateTime( 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.assignedDateTime ASC