How to get participants that have 2 or more specimens collected?

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.

1. 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.