Query for specimens stored over one year post-shipment receipt.

Create a ‘New Query’.

Expand the ‘Specimen’ section to add the following filter:

• Specimen >> Shipment Name Exists

• Specimen >> Container Name Exists

• Add temporal expression as: years_between(current_date(),Specimen.specimenShipments.receivedDate) >1

Click on ‘View Records’ and select the columns.
Under Specimens:

1. Specimen label, location details

2. Shipment Shipped Event: choose required fields like sending site, shipped date, etc.

3. Shipment Received Event: choose required fields like receiving site, receiving date, etc.

4. Temporal filter field
   
   

   Open

   

Save the Query.