LIMS.eu

To create rules/targets in your laboratory database, you first need a specification/limit value table. Select the specification where you want to add a target value, or add another one via + Create specification.

Parameter selection
There are two ways to add parameters:

1. Targeted search: Click on Search parameters and select the desired parameter

2. Use overview: Click on show all parameters and add parameters by clicking on the + next to the parameter

You will then automatically reach the view where you can create rules for parameters and thus define the target value.

Important: In the standard configuration of the laboratory database, you always define a valid value range, values that are outside are marked with the selected color.

Select the column of the parameter to which the target value refers. If, for example, a dropdown is stored for the selected column that contains the target value, you can make a selection from it.

Alternatively, enter a specific value. For example, the upper limit 5.

Maximum value (upper limit)

• If the temperature should stay below 5 °C: Value < 5
• Values above 5 °C (e.g. 8 °C) are automatically marked in color

If there is a range within which the target value is located, you can define this by coupling an AND function with the corresponding comparison operators. E.g. greater than 3 and less than 5.

Range (between two values)

• For pH values between 3 and 5: Value > 3 AND < 5
• Use the AND function with corresponding comparison operators
• Values that are <= 3, or >= 5, are automatically marked in color

If there is a range outside of which the target value is located, you can define this by coupling an OR function with the corresponding comparison operators. E.g. less than 3 or greater than 5.

Outside a range

• For values less than 3 or greater than 5: Value < 3 OR > 5
• Use the OR function with corresponding comparison operators
• Values that are in the range 3 - 5 are automatically marked in color

If you match a string, for example a sensory result, the result must be checked with a = or != (not equal).

Fixed value (exact match)

• If only "neutral" is accepted as odor: Value = neutral
• Values that are != neutral are automatically marked in color

When combining text and number, the text must come first. E.g. "=nn" OR "<10"

Set frequency
Define with what frequency this target value must be present in the tested samples (e.g. every 2nd sample).

Color coding
Select the color in which values are displayed that do not correspond to the target value (red by default).

Report integration
Check the checkbox "show this rule in report" to display target values together with measured values in reports.

Adding additional target values

After saving, you can add additional target values for the same parameter:

• Click on the + next to the parameter
• Define additional rules according to the same scheme

According to the created rules, the target values are now integrated into the laboratory database view where you enter values for samples. At first glance, you can see whether the measured values are within the range of your defined target values. Measured values deviating from the target value are displayed, for example, in the color "red".