• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • Query Condition - Number of Aliquots

    There have been cases where we would like to know how many specimens are available for a given study for given time points, though can only pull the specimens if doing so would not exhaust the collection. Requests of this kind are typically for large collections.

    Example: Within [Collection Protocol name], find available serum samples at Baseline, 1-Year Follow Up, and 4-Year Follow Up for participants with >1 available serum specimens at all three timepoints only.

    We’ve used filtering and sorting within Excel to come up with the results for queries like the above, which can be somewhat time consuming. Is there a query filter for number of specimens or aliquots?

    Hello @Matthew_Marcetich,

    For the example you have provided, you will need to use intersection so that it returns only those participants who have serum samples in all three time points.
    Refer to https://catissueplus.atlassian.net/wiki/x/O4BLAQ for help on creation of intersection query.

    In OS v1.0, you will get the actual specimens data and not just counts.
    Getting count of specimens per time point is possible in OS v1.1 as we have aggregate functions ability implemented.

    Thanks,
    Poornima