Database SQL Operation: WorkQueue.searchWorkQueueSubscriptionsForUser
Description: | Returns the summary details of all of the work queues that the specified user is subscribed to. |
Sterotype: | nsmulti |
SELECT
wq.workQueueID,
wq.name,
wq.allowUserSubscriptionInd,
wq.sensitivity,
wq.administratorUserName
INTO
:workQueueID,
:name,
:allowUserSubscriptionInd,
:sensitivity,
:administratorUserName
FROM
WorkQueue wq,
WorkQueueSubscription wqs
WHERE wq.workQueueID = wqs.workQueueID
AND userName = :userName
ORDER BY name
|