Database SQL Operation: WorkQueue.searchAdministratorUserWorkQueues
Description: | Returns a list of the details for all of the work queues that the specified user is an administrator of or has the sensitivity for. |
Sterotype: | nsmulti |
SELECT
name,
wq.workQueueID
INTO
:name,
:workQueueID
FROM
WorkQueue WQ
WHERE
(
(
WQ.administratorUserName = :administratorUserName
)
OR
(
WQ.allowUserSubscriptionInd = '1'
AND
(
WQ.sensitivity <=
(
SELECT
sensitivity
FROM
Users
WHERE userName = :administratorUserName
)
)
)
)
|