Links

Relation Flowchart

Show record relation in flowchart

Overview

In Labii ELN & LIMS, a record relationship can be set up through a ForeignKey or ForeignKeys. For instance, a box is stored in a refrigerator, and the refrigerator sits in a laboratory. The Relation Flowchart can provide an overview of such a relationship.
Among the most common applications for the Relation Flowcharts is to manage samples. For example, blood was used to extract DNA, which was then used to make a library for deep sequencing.

How to use

To use Relation Flowchart, please make sure:
  • The table has ForeignKey or ForeignKeys columns
  • There are multiple records referring to each other with the same column
To use it:
  1. 1.
    Add a section with Relation Flowchart widget
  2. 2.
    Click Edit to configure
    1. 1.
      Choose a Column to track
    2. 2.
      Choose a Text Column to display the text between two boxes.
    3. 3.
      Choose the flowchart direction
  3. 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.