Relation Flowchart

Show record relation in flowchart

Overview

The record relationship can be linked via ForeignKey or ForeignKeys in Labii ELN & LIMS. For example, A box stored in a refrigerator, and the refrigerator sits in a laboratory. The Relation Flowchart can be used to display such a relationship.

Once common use case for Relation Flowchart is the sample management. For example, blood was used to extract DNA, and the DNA was then used to prepare a library for deep sequencing.

How to use

To use Relation Flowchart, please make sure:

  • The table has ForeignKey or ForeignKeys columns

  • Multiple records are referring each other with the column

To use it:

  1. Add a section with Relation Flowchart widget

  2. Click Edit to configure

    1. Choose a Column to track

    2. Choose the flowchart direction

  3. Click Submit

Relation Flowchart for ForeignKey
Relation Flowchart for ForeignKeys

The relation flowchart build from ForeignKey only have one path, however, the flowchart build from ForeignKeys can have multiple paths.

Note: The box is clickable to see more detail of the record.

Note: The loading speed for the widget is a little bit slow, this is because it searching the upstream and downstream at the real time.