Search for samples that are not reserved

Example: User wishes to display the list of specimens that are not reserved for any distribution

The details about ‘Reservation ID’, ‘Reservation DP’ and ‘Reservation Date’ in the subform ‘Reservation Details’ are present only for specimens that are currently reserved for some distribution. These filters can be used to find out the specimens that are/are not reserved for a distribution protocol.
More details about reserving specimens: https://openspecimen.atlassian.net/wiki/pages/createpage.action?spaceKey=CAT&title=Reserve%20Specimens%20for%20Distribution&linkCreation=true&fromPageId=473825281

Steps to create a query:

  1. Go to ‘Home’ > ‘Queries’ > ‘Create’

  2. Search for ‘Reservation Details’ under ‘Specimen’ filter on the left-hand side

  3. Click on ‘Reservation ID’, select the operator as ‘Not Exists’ and ‘Add’

     

  4. All other additional conditions can be added along with this filter. This filter will ensure that no reserved specimens appear in the result view.

Sample Query: