Operation Details
Description: Returns all cases that a participant has a case participant role (case participant roles other than those on Social Enterprise Folders) and excluding those that have already been added to this Social Enterprise Folder.
Sterotype: nsmulti
SQL 
SELECT
  caseID
INTO
  :caseID 
FROM
  CaseParticipantRole 
WHERE participantRoleID = :participantRoleID 
  AND caseID ^ = ALL
  
  ( 
  SELECT
    caseID 
  FROM
    CaseHeader 
  WHERE caseTypeCode = :caseTypeCode 
  )