Query for specimens stored over one year post-shipment receipt.
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

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

You are trying to create a report of all specimens that were stored for more than a year after being received at the facility.

  1. Create a ‘New Query’.

  2. 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

image-20260220-073849.png
  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

      image-20260220-074507.png
  2. Save the Query.

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com