/
Display ancestor requirement name/code on child specimens
Got feedback or spotted a mistake?

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

Display ancestor requirement name/code on child specimens

Use case: Let WB1 be Maternal blood with the requirement name as ‘Maternal'. Let WB2, WB3, etc. be Cord blood with the requirement name as 'Cord’. If you now want a report from OpenSpecimen where you need to know if the aliquots (planned/unplanned) created under these blood specimens are maternal or cord, you can use this type of query to differentiate between the child specimens.

Steps:

  • Navigate to 'Queries'.

  • Click on '+Create.'

  • Add required filters:

  • Click on ‘View Records' → Actions → Columns

  • Open 'Specimen' form → Ancestor Requirements

  • Save the query.

The aliquot’s SR Name and Code will also be visible in the query because in computer science every node is an ancestor of self. This makes implementations efficient and easy to prove.

Related content

Hierarchical Queries
Hierarchical Queries
More like this
Configure Specimen Collection Page (nth Step)
Configure Specimen Collection Page (nth Step)
Read with this
Hierarchical query for child samples based on conditions of parent specimens
Hierarchical query for child samples based on conditions of parent specimens
More like this
Why do specimen hierarchical queries return incorrect results?
Why do specimen hierarchical queries return incorrect results?
Read with this
How to find N child specimens (sequence)?
How to find N child specimens (sequence)?
More like this
Set default value for child based on value of parent/primary specimen
Set default value for child based on value of parent/primary specimen
Read with this
Got feedback or spotted a mistake?

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