Operation Details
Description: Searches for tasks that are due for a specified work queue within the supplied date range. The results can be filtered to return assigned, reserved or all tasks as required. The results are ordered by assigned date time, earliest first. @deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment# searchTasksByDueDate(TaskIDRelatedIDAndTypeKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  t.taskID,
  t.priority,
  t.reservedBy,
  t.assignedDateTime,
  u.fullName,
  t.wdoSnapshot,
  t.overflowInd,
  w.deadlineTime
INTO
  :taskID,
  :priority,
  :reservedBy,
  :assignedDateTime,
  :reservedByFullName,
  :wdoSnapshot,
  :overflowInd,
  :deadlineDateTime 
FROM
  Task t 
  
  LEFT OUTER JOIN
  
  Users u 
  ON (t.reservedBy = u.userName) 
  
  LEFT OUTER JOIN
  
  WorkflowDeadline w 
  ON (t.taskID = w.taskID) 
WHERE w.deadlineTime >= :fromDeadlineDateTime 
  AND w.deadlineTime < :toDeadlineDateTime 
  AND 
  (
    t.taskID IN 
    ( 
    SELECT
      taskID 
    FROM
      TaskWorkQueueAssignment twqa 
    WHERE twqa.workQueueID = :workQueueID 
    ) 
  ) 
  AND 
  (
    
    (
      :allWorkQueueTasksInd = '0' 
      OR 
      (
        t.reservedBy IS NULL 
        OR t.reservedBy IS NOT NULL 
      ) 
    ) 
    AND 
    (
      :allReservedWorkQueueTasksInd = '0' 
      OR t.reservedBy IS NOT NULL 
    ) 
    AND 
    (
      :allAssignedWorkQueueTasksInd = '0' 
      OR t.reservedBy IS NULL 
    ) 
  ) 
ORDER BY t.assignedDateTime ASC