OpenSpecimen stores specimens at participant level. There can be one or more consent statements defined for a CP with responses "Yes", "No", or "Withdrawn".
This query example shows how to search for all participants who have said "Yes" for "Consent to process RNA and DNA samples". You can view this query on the demo site here: <SR: Create this on demo site>
- Go to home page and click on 'Queries' card
- Click on 'Create' button from queries list page
Add filter: 'Participant-->Consent Statement-->Equals-->Consent to process RNA and DNA samples'
- Add filter: 'Participant-->Consent Response-->Equals-->Yes'
SR: Update this screenshot
Click on 'View Records' button
Query with multiple consent statements
To handle multiple consent statements, repeat the above by using "Is One Of" filter condition.
(Consent statement "is one of" ABC, XYZ) and Consent Response = Yes)
<SR Attach screenshot for is one of example>
Defining results view
Follow the steps to add columns in the results table of the created query:
- Click on 'Columns' button from the query results page
- Select the columns that you wish to view in the results table by checking the checkbox and click on 'Done' button
- <SR: Add specimen label also in the view>
You can now view the records with participant and specimen details
