Operation Details
Description: Returns a list of all the task identifiers from the task user assignment table for all of the redirect task to users that have currently active task redirection records. The name of the user from which the tasks will be redirected from and the name of the user to which the tasks will be redirected are also returned. @deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment#searchTaskUserAssignmentsByActiveTaskRedirection(TaskUserAssignmentByActiveTaskKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  tua.taskID,
  tr.fromUserName,
  tr.toUserName
INTO
  :taskID,
  :fromUserName,
  :toUserName 
FROM
  TaskRedirection tr 
  
  LEFT OUTER JOIN
  
  TaskUserAssignment tua 
  ON tr.fromUserName = tua.userName 
WHERE tua.taskID IN 
  ( 
  SELECT
    taskID 
  FROM
    TaskUserAssignment 
  WHERE userName = tr.fromUserName 
  ) 
  AND tua.taskID NOT IN 
  ( 
  SELECT
    taskID 
  FROM
    TaskUserAssignment 
  WHERE userName = tr.toUserName 
  ) 
  AND :currentDateTime >= tr.startDateTime 
  AND 
  (
    
    (
      :currentDateTime < tr.endDateTime 
    ) 
    OR 
    (
      tr.endDateTime IS NULL 
    ) 
  ) 
ORDER BY tr.fromUserName