Database SQL Operation: TaskWorkQueueAssignment.searchUnreservedByWorkQueueAndLongestAssignedDateTime
Description: | Returns a list of task identifiers that have been assigned to a work queue that the specified user is subscribed to. The list of tasks returned are sorted by by the length of time that they have been assigned and then by the priority of the tasks.
@deprecated Since Curam 6.0. The TaskWorkQueueAssignment 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
TaskWorkQueueAssignment twqa,
Task t
WHERE twqa.workQueueID = :workQueueID
AND twqa.taskID = t.taskID
AND t.reservedBy IS NULL
ORDER BY t.assignedDateTime ASC,
t.priority ASC
|