Operation Details |
Description: | Returns the count for the number of tasks assigned to a user. |
Sterotype: | ns |
SQL |
SELECT COUNT (*) INTO :numberOfRecords FROM TaskAssignment ta, Task t WHERE ta.relatedName = :userName AND ta.taskID =t.taskID AND t.reservedBy IS Null |