Operation Details |
Description: | Returns a count of the number of available tasks assigned to the specified work queue. The assignee type is set to Work Queue in the SQL. |
Sterotype: | ns |
SQL |
SELECT COUNT(Task.taskID) INTO :numberOfItems FROM TaskAssignment, Task WHERE TaskAssignment.relatedID = :workQueueID AND TaskAssignment.assigneeType = 'RL23' AND Task.taskID = TaskAssignment.taskID AND reservedBy IS NULL |