Operation Details
Description: Returns the deadline date time and reserved by user name of the tasks that are due for a specified user during a specified time period. The details returned include those tasks that have been directly assigned plus those tasks present on work queues that the specified user is subscribed to. @deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment#searchUserWorkQueueTasksDueInTheNextTimePeriod(TasksDueInTheNextTimePeriodKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  w.deadlineTime,
  t.reservedBy
INTO
  :deadlineDateTime,
  :reservedBy 
FROM
  Task t 
  
  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
      TaskUserAssignment u 
    WHERE u.userName = :userName 
    ) 
    OR 
    (
      t.taskID IN 
      ( 
      SELECT
        taskID 
      FROM
        TaskWorkQueueAssignment tw 
      WHERE tw.workQueueID IN 
        ( 
        SELECT
          workQueueID 
        FROM
          WorkQueueSubscription wq 
        WHERE wq.userName = :userName 
        ) 
      ) 
    ) 
  ) 
ORDER BY deadlineTime