Query to find unplanned specimens
Got feedback or spotted a mistake?

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

Query to find unplanned specimens

You are trying to find all unplanned specimens within your collection protocol.

  1. Create a ‘New Query’.

  2. Expand the ‘Collection Protocol’ section to add a collection protocol.

    1. Collection Protocol >> Short Title Equals Demo Longitudinal Study

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

    1. Specimen >> Requirement Code Not Exists

    2. Specimen >> Lineage Equals New

      image-20260312-072727.png
  4. Click on ‘View Records’ and select the columns as needed.

    1. CP short title

    2. Visit name

    3. Specimen labels

  5. Save query.

 

Got feedback or spotted a mistake?

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