Operation Details
Description: @deprecated Since Curam 6.0 , replaced with {@link WorkQueueSubscription#searchExternalSubscriptionsByWorkQueueID( UserNameSubscriberAndWorkQueueKey)}. As part of the Code Compliancy changes, implementation has been moved to searchExternalUserSubscriptionsByWorkQueueID. This method returns 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 external subscriptions to a specified work queue.
Sterotype: nsmulti
SQL 
SELECT
  workQueueSubscriptionID,
  ExternalUser.userName,
  fullName, 
  subscriptionDateTime
INTO
  :workQueueSubscriptionID,
  :userName,
  :userFullName, 
  :subscriptionDateTime 
FROM
  WorkQueueSubscription ,
  ExternalUser 
WHERE WorkQueueSubscription.workQueueID = :workQueueID 
  AND WorkQueueSubscription.userName = ExternalUser.userName 
  AND WorkQueueSubscription.subscriberType = 'RL50' 
  AND ExternalUser.statusCode = 'RST1'