Operation Details
Description: Returns a list of all the task redirection records for a specified redirect from user.
Sterotype: nsmulti
SQL 
SELECT
  t.taskRedirectionID,
  t.toUserName,
  u.fullName,
  t.startDateTime,
  t.endDateTime,
  t.versionNo,
  t.toRedirectID,
  t.toRedirectType
INTO
  :taskRedirectionID,
  :toUserName,
  :toUserFullName,
  :startDateTime,
  :endDateTime,
  :versionNo,
  :toRedirectID,
  :toRedirectType 
FROM
  TaskRedirection t 
  
  LEFT OUTER JOIN
  
  Users u 
  ON (t.toUserName = u.userName) 
WHERE t.fromUserName = :fromUserName 
  AND t.blockTaskAllocation = :blockTaskAllocation 
ORDER BY t.startDateTime