Database SQL Operation: TaskUserAssignment.searchUnreservedByUserNamePriorityAndLongestAssignedDateTime
Description: | Returns a list of task identifiers that have been assigned to the specified user. The list of tasks returned are sorted by priority and then by the length of time that they have been assigned to that user.
@deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by
{@link curam.core.sl.entity.intf.TaskAssignment#searchUnreservedByAssigneePriorityAndLongestAssignedDateTime(TaskIDRelatedIDAndTypeKey)}. See release note CR00223130. |
Sterotype: | nsmulti |
SELECT
t.taskID
INTO
:taskID
FROM
TaskUserAssignment tua,
Task t
WHERE tua.userName = :userName
AND tua.taskID = t.taskID
AND t.reservedBy IS NULL
ORDER BY t.priority ASC,
t.assignedDateTime ASC
|