Database SQL Operation: TaskAssignment.searchWorkQueueSubscriptionByTaskID
Description: | This method is called in the TaskManagement.validateReserve() method to check that either the task is assigned to the current user or else that the task is assigned to a work queue to which the current user is subscribed. |
Sterotype: | nsmulti |
SELECT
WorkQueueSubscription.userName
INTO
:userName
FROM
WorkQueueSubscription,
TaskAssignment ta
WHERE ta.taskID = :taskID
AND ta.assigneeType = :assigneeType
AND ta.relatedID = WorkQueueSubscription.workQueueID
|