Database SQL Operation: TaskUserAssignment.searchUnreservedByUserNameAndLongestAssignedDateTime
Description: | Returns a list of task identifiers that have been assigned to the specified user. The list of tasks returned are sorted by the length of time that they have been assigned to that user and then by the priority of the tasks.
@deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by
{@link curam.core.sl.entity.intf.TaskAssignment#searchAssignedByRelatedIDTypeAndLongestAssignedDateTime(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.assignedDateTime ASC,
t.priority ASC
|