Operation Details
Description: Join across CaseHeader and ConcernRole. Returns details about all cases of the specified type created for the particular case participant.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseID,
  CaseHeader.caseTypeCode,
  CaseHeader.startDate,
  CaseHeader.statusCode,
  ConcernRole.concernRoleID,
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleType
INTO
  :caseID,
  :caseTypeCode,
  :startDate,
  :statusCode,
  :concernRoleID,
  :concernRoleName,
  :concernRoleType 
FROM
  CaseHeader,
  ConcernRole 
WHERE CaseHeader.concernRoleID = :concernRoleID 
  AND CaseHeader.caseTypeCode = :caseTypeCode 
  AND ConcernRole.concernRoleID = :concernRoleID 
  AND 
  (
    CaseHeader.statusCode <= :statusCode 
    OR CaseHeader.statusCode >= :statusCode 
  )