Database SQL Operation: CaseParticipantRole.searchCaseIDByPRIDTypeCodesAndStatus
Description: | This method retrieves all case IDs from the CaseParticipantRole table that match the given participant role ID, status and either one of two type codes. |
Sterotype: | nsmulti |
SELECT
caseID
INTO
:caseID
FROM
CaseParticipantRole
WHERE
(
CaseParticipantRole.typeCode = :typeCode1
OR CaseParticipantRole.typeCode = :typeCode2
)
AND CaseParticipantRole.participantRoleID = :participantRoleID
AND CaseParticipantRole.recordStatus = :recordStatus
|