Query Checked-Out Specimens

Using the query module, you can create a query to fetch the details of the last checked-out event, i.e. search for currently checked-out specimens

Follow the below-mentioned steps:

1. Navigate to Query → Create

2. Click on the Specimen form and under the ‘Checkout Details’ section

3. Select the field,  ‘Container Name’ and add the filter as ‘Exists’

   Open

   

4. The filter will look like below after adding

   Open

   

5. Click on ‘View Records’

6. Click on ‘Actions’ → ‘Columns’ to configure the columns.

7. Select the fields under the ‘Checkout Details’ section to view the details of the checked-out specimens.

8. This will display all the checked-out sample

9. Ref Query: https://test.openspecimen.org/#/queries/results?queryId=6818

10. You can also download the query definition and import it on your server