SQL:ISHouseholdEvidence.countByCaseEvidenceTreeIDAndEvidenceType

Operation Details

Description:	Returns the number of evidence records in the tree of the particular evidence type.
Sterotype:	ns

SQL

SELECT
  COUNT(*)
INTO
  :numberHouseholdMembers 
FROM
  CaseEvidenceTree,
  CaseEvidenceGroup,
  CaseEvidenceGroupLink 
WHERE CaseEvidenceTree.caseEvidenceTreeID = :caseEvidenceTreeID 
  AND CaseEvidenceGroup.caseEvidenceTreeID = CaseEvidenceTree.caseEvidenceTreeID 
  AND CaseEvidenceGroup.caseEvidenceGroupID = CaseEvidenceGroupLink.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.evidenceType = :evidenceType

Database SQL Operation: ISHouseholdEvidence.countByCaseEvidenceTreeIDAndEvidenceType