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. @deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment#searchTaskUserAssignmentsByActiveTaskAllocationBlockingPeriod(TaskUserAssignmentByActiveTaskKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  tua.taskID,
  tr.fromUserName
INTO
  :taskID,
  :fromUserName 
FROM
  TaskRedirection tr,
  TaskUserAssignment tua,
  Task task 
WHERE tr.fromUserName = tua.userName 
  AND tua.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 tua.taskID