Operation Details |
Description: | Returns a list of case group members of the specified type for a case. |
Sterotype: | nsmulti |
SQL |
SELECT ConcernRole.concernRoleName, ConcernRole.concernRoleID, CaseGroups.startDate, CaseGroups.endDate INTO :eligibleMemberName, :concernRoleID, :startDate, :endDate FROM CaseGroups, ConcernRole WHERE CaseGroups.caseID = :caseID AND CaseGroups.groupCode = :groupCode AND ConcernRole.concernRoleID = CaseGroups.concernRoleID |