Database SQL Operation: TaskWorkQueueAssignment.searchUnreservedByWorkQueuePriorityAndLongestAssignedDateTime
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 priority and then by the length of time that they have been assigned.
@deprecated Since Curam 6.0. The TaskWorkQueueAssignment 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
TaskWorkQueueAssignment twqa,
Task t
WHERE twqa.workQueueID = :workQueueID
AND twqa.taskID = t.taskID
AND t.reservedBy IS NULL
ORDER BY t.priority ASC,
t.assignedDateTime ASC
|