Operation Details
Description: Returns a list of summary details for active and pending task redirection or task allocation blocking records for the specified user. @deprecated Since Curam 6.0, this method has been replaced by {@link #searchByFromUserStartDateAndEndDateTime()} See release note CR00225257
Sterotype: nsmulti
SQL 
SELECT   

tr.taskRedirectionID,  
tr.blockTaskAllocation 

INTO   

:taskRedirectionID,     
:blockTaskAllocation  

 FROM   
TaskRedirection tr  
WHERE 
tr.fromUserName = :fromUserName    

AND 

( (:startDateTime >= tr.startDateTime        

AND 

:startDateTime <= tr.endDateTime )     

OR      

(:endDateTime >= tr.startDateTime        

AND 

:endDateTime <= tr.endDateTime)      

OR      

(:startDateTime < tr.startDateTime        

AND 

:endDateTime > tr.endDateTime ))