Versions Compared

Old Version 3

changes.mady.by.user Neha Nimgire

Saved on

compared with

New Version 4

changes.mady.by.user Srikanth Adiga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Hierarchical queries allows allow users to form searches to find child specimens based on some characteristics of its parent specimens. For example, DNA derived from tumor breast tissue specimens.

To form hierarchical queries, follow below steps:

  1. Create a new query by adding filters for parent and child specimens
  2. Add the hierarchical operator between parent and child filters. Hierarchical A hierarchical operator is indicated below:
  3. The operator needs to be placed before the child filters and after parent filters like below. The child filters should be closed in parenthesis.
  4. Click on view records and select specimen fields by clicking on columns. The columns selected will be displayed for both child and parent specimens. Currently, there is no way to select different columns for parent and child specimens.
Info

An example of a hierarchical query shipped with OpenSpecimen as a default query with the title 'Show details of a participant having DNA derived from Tumor Breast Frozen Tissue'. This can be used as a reference.


Note
titlePlease Note
  1. The fields column names for parent and child samples specimens cannot be renamed separately. Rename one fields, renames it for both the levelsThere are a few fields that can be displayed for both parent and child like label, barcode, quantity, storage location etcindividually.
  2. It is not possible to rearrange columns across levels. All the parent specimen columns are displayed first and followed by the child specimens.
  3. Some fields are displayed only at the parent level like since they have the same values across all levels. E.g. anatomic site, biohazard, specimen class, laterality, pathology status.It is not possible to arrange fields of these 2 levels. All the parent fields are listed out first and then the child specimen fields are shown.