Database SQL Operation: WorkQueueSubscription.searchOrgUnitSubscriptionsByWorkQueueID
Description: | Returns the organization object subscription to work queue. |
Sterotype: | nsmulti |
SELECT
workQueueSubscriptionID,
wqs.subscriberID,
ou.name AS subscriberName,
wqs.subscriberType,
wqs.subscriptionDateTime
INTO
:workQueueSubscriptionID,
:subscriberID,
:subscriberName,
:subscriberType,
:subscriptionDateTime
FROM
WorkQueueSubscription wqs,
OrganisationUnit ou
WHERE wqs.workQueueID = :workQueueID
AND wqs.subscriberType = :subscriberType
AND wqs.subscriberID = ou.organisationUnitID
AND ou.recordStatus = :recordStatus
|