Database SQL Operation: TaskRedirection.searchTaskAllocationBlockingPeriodsByRedirectFromUserName
Description: | Returns a list of all the task allocation blocking records for a specified redirect from user. |
Sterotype: | nsmulti |
SELECT
tr.taskRedirectionID,
tr.startDateTime,
tr.endDateTime,
tr.versionNo
INTO
:taskRedirectionID,
:startDateTime,
:endDateTime,
:versionNo
FROM
TaskRedirection tr
WHERE tr.fromUserName = :fromUserName
AND tr.blockTaskAllocation = :blockTaskAllocation
ORDER BY tr.startDateTime
|