Filter by Total Aliquot Quantity (v8.0)

This feature helps you search for specimens based on the total quantity of aliquots. For example, you want to search and distribute 5 ml plasma per patient where the plasma can be from multiple aliquots of the same parent. Earlier this was difficult to find since the query interface filtering worked on individual specimen quantity. With this new feature, you can use filter specimens by the total quantity of aliquots.

Example 1: Show plasma aliquots from the same participant where there are 3ml available.

  • Navigate to 'Queries'.

  • Create a query using desired filters.

  • Click on 'View records' → Action → Columns.

  • Add the 'Specimen Available Quantity' field to view the quantity.

  • In the ‘Reporting Options', select the report type as ‘Limit specimens by cumulative quantities’ → Limit by as 'Participant’.

  • Enter the minimum and maximum quantity → Done.

  • The query will show a total of 3ml plasma aliquots per participant.

  • When you say limit by participant, 'Registration ID' is mandatory to be part of columns.

  • Specimen Type should be a part of columns as the query is about showing plasma aliquots from the same participant.

Example 2: Show serum aliquots with a restriction that no less than and no more than 4ml of serum from the same aliquot group should be picked.

  • Navigate to 'Queries'.

  • Create a query using desired filters.

  • Click on 'View records' → Action → Columns.

  • Add the 'Specimen Available Quantity' field to view the quantity.

  • In the ‘Reporting Options', select the report type as ‘Limit specimens by cumulative quantities’ → Limit by as 'Parent Specimen’.

  • Enter the minimum and maximum quantity → Done.

  • The query will show a total of 4ml serum aliquots per parent.

  • When you say limit by parent specimen, 'Parent Specimen Label' is mandatory to be part of columns.

  • Specimen Type should be a part of columns as the query is about showing serum aliquots.