Database SQL Operation: TaskRedirection.searchTaskRedirectionsByRedirectFromUserName
Description: | Returns a list of all the task redirection records for a specified redirect from user.
@deprecated Since Curam 6.0, this method has been replaced by {@link #searchByRedirectFromUserName}. The new method also returns the ID and type of the organization object where the task is being redirected. |
Sterotype: | nsmulti |
SELECT
t.taskRedirectionID,
t.toUserName,
u.fullName,
t.startDateTime,
t.endDateTime,
t.versionNo
INTO
:taskRedirectionID,
:toUserName,
:toUserFullName,
:startDateTime,
:endDateTime,
:versionNo
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
|