Leave a comment at the end of this page or email contact@krishagni.com
How to find N child specimens (sequence)?
Pre v10.2, this field is called “Aliquot Sequence” and supported only aliquot count.
From v10.2 onwards, the ‘Aliquot Sequence’ field is renamed to ‘Sequence’ and is available for both aliquot and derived child specimens.
The sequence is computed by grouping the available specimens using their visit ID, parent specimen ID, and specimen type attributes.
Following examples will to understand the sequence better.
Parent Sample Sequence: If you create 2 specimens of the same type under a visit, then they will get sequence 1 and 2.
Visit Name | Parent Label | Sequence |
---|---|---|
VN01 | Whole_Blood_01 | 1 |
VN01 | Fresh_Tissue_02 | 1 |
VN01 | Urine_03 | 1 |
VN01 | Urine_04 | 2 |
VN02 | Whole_Blood_01 | 1 |
VN02 | Whole_Blood_02 | 2 |
Derivative Example: If there are 3 different types of derivatives created from a parent specimen then all these will get sequence as 1. On creating an additional specimen of the same type the counter gets increased by 1 which makes the sequence 2.
Visit Name | Parent Label | Derivative Label | Sequence |
---|---|---|---|
VN01 | WB01 | WB01_Plasma_01 | 1 |
VN01 | WB01 | WB01_Plasma_02 | 2 |
VN01 | WB01 | WB01_BuffyCoat_01 | 1 |
VN01 | WB01 | WB01_RBC_01 | 1 |
VN02 | WB01 | WB01_Plasma_01 | 1 |
VN02 | WB01 | WB01_Plasma_02 | 2 |
Aliquot Example:
Generally, when you search for aliquots, you are interested only in a subset that should be displayed in the query results and not all aliquots under a specimen. Using the 'Sequence' filter, limiting the number of aliquots displayed per parent specimen in the query results is possible.
It is a dynamic virtual counter which generates the sequence for the aliquots under a parent specimen for the query, starting from 1.
For example, a user wants to view 1 aliquot parent specimen. A filter can be applied in the query as "Specimen >> Specimen Statistics >> Sequence Equals 1"
A system job, 'Scheduler to refresh specimen additional details,' is scheduled to run every night. This allows the updating of the aliquot sequence. More information on jobs: System Jobs
Leave a comment at the end of this page or email contact@krishagni.com