Database SQL Operation: WorkQueue.searchUserWorkQueues
| Description: | @deprecated Since Curam 6.0 , replaced with
{@link WorkQueue#searchWorkQueuesForUser(CurrentUserWorkQueueKey)}.
In addition to the current functionality, the new method return struct
curam.core.sl.entity.struct.CurrentUserWorkQueueAndSubscriberDetailsList aggregates
curam.core.sl.entity.struct.CurrentUserWorkQueueAndSubscriberDetails, and this
struct contains all the fields of CurrentUserWorkQueueDetails along with subscriberID,
subscriberName, subscriberType, pageTitle and unsubscribePageText.
See release note : <CR00226714> |
| Sterotype: | nsmulti |
SELECT
name,
WorkQueue.workQueueID,
subscriptionDateTime
INTO
:workQueueName,
:workQueueID,
:subscriptionDateTime
FROM
WorkQueue,
WorkQueueSubscription
WHERE WorkQueue.workQueueID = WorkQueueSubscription.workQueueID
AND userName = :userName ORDER BY name
|
