Query for participants registered to multiple CPs

For a participant that is registered to multiple collection protocols, the Participant ID is the same across protocols.

Users can create queries for the participants that are registered to multiple CPs say CP1, CP2 and CP3 using the steps mentioned below.

Go to queries and add a filter for the field 'CP Short Title' → Operator - 'Is One Of' → Condition Value - CP1, CP2 and CP3. (Add the collection protocols for which you want to find)
View Records → Action → Columns
Select fields - CP Short title, Participant ID, and PPID.

4. Click on ‘Next' and select 'Count’ for PPID field.

4. For better visualization, create a pivot table as displayed in the screenshot

5. The result will be a pivot table with the count of the participants registered to multiple CPs. In the screenshot below, the participant with ID 2545 is registered to 2 CPs - 'MES-PW' and 'MES-PW2', whereas 38071 is registered to only 1 CP MES-PW1.

For performance reasons, only the top 1,000 rows are displayed on the results page. If the protocol has more than 1,000 registrations, there is a possibility that the participant you are searching for may not appear on the results page.

In that case: You can export the query result and use Excel filters to narrow down your search.

Attached below is the sample query for user reference. You can go Query → Import (Choose the below file). Once the query is imported, edit the filters and add the CP names for which query is to be executed.

Sample query