Example: A user wishes to display all the specimens in OpenSpecimen along with their availability, that is, whether they are reserved, distributed or available.
This can be done by filtering specimens on the basis of the 'Reserved event' and 'Distributed event' using the following steps:
The specimen labels for which there exists value in 'Reserved Event > Distribution Protocol' are reserved specimens. Specimens which have data under 'Distributed Event > Distribution Protocol'.
The data view can be sorted in ascending/descending order by clicking on the column headers. The range for 'Reserved ID'/ 'Distributed ID' can be specified in the left-hand side filters, starting from 1.
This query definition (JSON) file can be imported from here: SpecimensQuery