Page Comparison

OpenSpecimen stores specimens at participant level. There can be one or more consent statements defined for a CP with responses "Yes", "No", or "WithdrawnNot Specified".

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>'Consent Based Query'

1. Go to home page and click on 'Queries' card
2. Click on 'Create' button from queries list page

3. Add filter: 'Participant-->Consent Statement-->Equals-->Consent to process RNA and DNA samples'

   Add filter: 'Participant-->Consent Response-->Equals-->Yes'

   Image Removed
   

   SR: Update this screenshot

   Image Added
   
   

4.  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) [Consent to process DNA, Consent to store the samples for research] and Consent Response = Yes)<SR Attach screenshot for is one of example>

            Image Added

Defining results view

Follow the steps to add columns in the results table of the created query:

1. Click on 'Columns' button from the query results page 
2. 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>

             Image Added

            Image Removed    

You can now view the records with participant and specimen details

            Image Removed  Image Added