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 |