Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
How to get participants that have 2 or more specimens collected?
You are trying to create a query to find participants who have had more than 2 tissue blocks collected.
Steps to create the Query:
Create a ‘New Query’.
Expand the ‘Participant’ section to add the following filter:
Participant >> PPID Exists
Expand the ‘Specimen’ section to add the following filter:
Specimen >> Type Equals Tissue - Block
Click on ‘View Records’ and select the columns: PPID, Specimen Label, and others as required.
Click ‘Next’. Under ‘Aggregates’, add a count function on the Specimen Label.
Click ‘Next'. Under ‘Reporting Options’-> ‘Aggregate filters’, add filter:
count(Specimen.label) > 2
Click ‘Done’. Save the Query.