Operation Details
Description: Returns a list of all the task identifiers from the task user assignment table and the names of all the users that have currently active task allocation blocking records.
Sterotype: nsmulti
SQL 
SELECT
  ta.taskID,
  tr.fromUserName
INTO
  :taskID,
  :fromUserName 
FROM
  TaskRedirection tr,
  TaskAssignment ta,
  Task task 
WHERE tr.fromUserName = ta.relatedName 
  AND ta.taskID = task.taskID 
  AND task.reservedBy IS NULL 
  AND :currentDateTime >= tr.startDateTime 
  AND 
  (
    
    (
      :currentDateTime < tr.endDateTime 
    ) 
    OR 
    (
      tr.endDateTime IS NULL 
    ) 
  ) 
  AND :blockTaskAllocation = tr.blockTaskAllocation 
ORDER BY ta.taskID