Operation Details
Description: @deprecated Since Curam 6.0 , replaced with {@link WorkQueueSubscription#searchUserSubscriptionsByWorkQueueID( UserNameSubscriberAndWorkQueueKey)}. In addition to the current functionality, the new method return struct curam.core.sl.entity.struct.WorkQueueSubscriptionFullDetailsList which aggregates struct curam.core.sl.entity.struct.WorkQueueSubscriptionFullDetails, and this struct has all the fields of WorkQueueSubscriptionDetails along with fields subscriberID, subscriberName, subscriberType, unsubscribePageText, pageTitle, organisationUnitID, organisationStructureID and objectType. See release note : <CR00225579> Search for all user subscriptions to a specified work queue.
Sterotype: nsmulti
SQL 
SELECT
  workQueueSubscriptionID,
  Users.userName,
  fullName,
  subscriptionDateTime
INTO
  :workQueueSubscriptionID,
  :userName,
  :userFullName,
  :subscriptionDateTime 
FROM
  WorkQueueSubscription,
  Users 
WHERE WorkQueueSubscription.workQueueID = :workQueueID 
  AND WorkQueueSubscription.userName = Users.userName 
  AND Users.statusCode = 'RST1'