Operation Details
Description: Returns a list of task details for the specified external user. The list of tasks returned may be reserved, unreserved or all of the tasks assigned to the specified external user depending on the search criteria. @deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment#searchExternalUsersTasksByName(TasksByDueDateKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  t.taskID,
  t.priority,
  t.reservedBy,
  e.fullName,
  t.assignedDateTime,
  w.deadlineTime,
  t.wdoSnapshot,
  t.overflowInd
INTO
  :taskID,
  :taskPriority,
  :taskReservedByUserName,
  :taskReservedByFullUserName,
  :taskAssignedDateTime,
  :taskDeadlineDateTime,
  :wdoSnapshot,
  :overflowInd 
FROM
  Task t 
  
  LEFT OUTER JOIN
  
  ExternalUser e 
  ON (t.reservedBy = e.userName) 
  
  LEFT OUTER JOIN
  
  WorkflowDeadline w 
  ON (t.taskID = w.taskID) 
WHERE 
  (
    t.taskID IN 
    ( 
    SELECT
      taskID 
    FROM
      TaskUserAssignment tua 
    WHERE tua.userName = :userName 
    ) 
    OR 
    (
      t.taskID IN 
      ( 
      SELECT
        taskID 
      FROM
        TaskWorkQueueAssignment tw 
      WHERE tw.workQueueID IN 
        ( 
        SELECT
          workQueueID 
        FROM
          WorkQueueSubscription wq 
        WHERE wq.userName = :userName 
        ) 
      ) 
    ) 
  ) 
  AND 
  (
    
    (
      :allUserTasksInd = '0' 
      OR 
      (
        t.reservedBy IS NULL 
        OR t.reservedBy IS NOT NULL 
      ) 
    ) 
    AND 
    (
      :allReservedUserTasksInd = '0' 
      OR t.reservedBy IS NOT NULL 
    ) 
    AND 
    (
      :allAssignedUserTasksInd = '0' 
      OR t.reservedBy IS NULL 
    ) 
  )