Database SQL Operation: EvidenceDescriptor.searchDistinctEvidenceParticipantsByCaseID
| Description: | <p>
<font color="#3F5FBF" size="2"><font color="#3F5FBF" size="2">Returns</font></font> <font color="#3F5FBF"
size="2"><font color="#3F5FBF" size="2">a</font></font> <font color="#3F5FBF" size="2"><font color="#3F5FBF"
size="2">list</font></font> <font color="#3F5FBF" size="2"><font color="#3F5FBF" size="2">of</font></font> <font
color="#3F5FBF" size="2"><font color="#3F5FBF" size="2">participants</font></font> <font color="#3F5FBF" size="2"><font
color="#3F5FBF" size="2">for</font></font> <font color="#3F5FBF" size="2"><font color="#3F5FBF"
size="2">a</font></font> <font color="#3F5FBF" size="2"><font color="#3F5FBF" size="2">case</font></font> <font
color="#3F5FBF" size="2"><font color="#3F5FBF" size="2">having</font></font> <font color="#3F5FBF" size="2"><font
color="#3F5FBF" size="2">evidence.</font></font>
</p> |
| Sterotype: | nsmulti |
SELECT
concernRoleName ,
concernRoleID
INTO
:participantName,
:participantID
FROM
ConcernRole
WHERE
concernRoleID
IN
(SELECT distinct participantID from EvidenceDescriptor where evidenceDescriptor.caseID = :caseID)
|
