Operation Details
Description: List unreserved task details for specified user name. @deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment#searchUnreservedByUserName(TaskAssignmentUserKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL
SELECT
  Task.taskID,
  Task.priority,
  Task.assignedDateTime,
  Task.wdoSnapshot,
  Task.overflowInd,
  WorkflowDeadline.deadlineTime
INTO
  :taskID,
  :priority,
  :assignedDateTime,
  :wdoSnapshot,
  :overflowInd,
  :dueDateTime 
FROM
  TaskUserAssignment,
  Task 
  
  LEFT OUTER JOIN
  
  WorkflowDeadline 
  ON WorkflowDeadline.taskID = Task.taskID 
WHERE TaskUserAssignment.userName = :userName 
  AND Task.taskID = TaskUserAssignment.taskID 
  AND Task.reservedBy IS NULL 
ORDER BY WorkflowDeadline.deadlineTime ASC