Database SQL Operation: TaskWorkQueueAssignment.countUnreservedByWorkQueue
Description: | Count the unreserved tasks in a specific work queue.
@deprecated Since Curam 6.0. The TaskWorkQueueAssignment entity has been
deleted. This method has been replaced by
{@link curam.core.sl.entity.intf.TaskAssignment#
countUnreservedByTargetRelatedIDType(TaskIDRelatedIDAndTypeKey)}. See
release note CR00223130. |
Sterotype: | ns |
SELECT
COUNT (*)
INTO
:numberOfRecords
FROM
TaskWorkQueueAssignment,
Task
WHERE TaskWorkQueueAssignment.workQueueID = :workQueueID
AND TaskWorkQueueAssignment.taskID = Task.taskID
AND Task.reservedBy IS NULL
|