Operation Details |
Description: | Searches all of a case's participants by gender. |
Sterotype: | nsmulti |
SQL |
SELECT concernRoleName, caseParticipantRoleID INTO :name, :caseParticipantRoleID FROM ConcernRole, CaseParticipantRole, Person WHERE CaseParticipantRole.caseID = :caseID AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID AND ( Person.concernRoleID = ConcernRole.concernRoleID AND Person.gender = :gender ) |