Link Evaluations

This guide describes how to create internal links in Labordatenbank evaluations to directly refer to sample details or other evaluations, including passing parameters and displaying open samples on dashboards.

Links can be generated in an evaluation to make the evaluation directly usable.
To get links in the table, a laboratory database internal linking system is necessary.
For example to link to the sample detail view the following command is used:
CONCAT('link==..\/samples\/view\/', samples.id, '==', samples.name) as 'Samples'
..\/samples\/view\/' = LDB-internal Link
samples.id = Part of the link
samples.name = Display value
'Samples' =Column heading

You can find more linking ideas in the examples.

It is also possible to link within the evaluations. The result of the link is inserted into the VAR0 of the linked evaluation.

SELECT
CONCAT('link==..\/stats\/view\/2\/html\/', employees.id, '==', count(samples.id)) as 'Link',
employees.lastname as 'Mitarbeiter'
FROM samples
LEFT JOIN employees ON samples.employee_id =employees.id

This evaluation shows the employees with their number of samples. The column 'Link' shows the number of samples `count(samples.id)` and linked with handover of the `employees.id` to evaluation No. 2 `'link==..\/stats\/view\/2\/html\/'`, where the ID is inserted into VAR0

Evaluation No. 2 with forwarding to sample list:

SELECT
samples.id,
CONCAT('link==..\/samples\/view\/', samples.id, '==', samples.name) as 'Samples',
FROM samples
JOIN employees ON  samples.employee_id=employees.id
WHERE samples.visible_to != 'deleted'
AND samples.done < samples.total
AND samples.status > 0
AND  samples.employee_id =_VAR0_;

With this evaluation No. 2, you can also display an overview of open samples to each employee on their dashboard.

To display the number of open samples per employee on the dashboard, you need another evaluation per employee (here the employee has ID 123):

SELECT
CONCAT('link==..\/stats\/view\/2\/html\/123==', count(DISTINCT samples.id)) as 'Number of open samples XY'
FROM samples
WHERE
samples.visible_to != 'deleted'
AND samples.done < samples.total
AND samples.status > 0
AND  samples.employee_id = 123;

Last change: 25.08.2025

Allgemeines

Einführungsphase

Auswertungen

Mitarbeiter

Aufträge

Proben

Probenvorlage

Berichte

Kunden

Berichtstabellen Editor

Kundenzone (optional)

Anlagen

Angebote

Rechnungen

Parameter

Rechnen mit Parametern

Schnittstellen

Webservice

Transformationscode

Prüfpläne / Grenzwerte / Spezifikationen

Dokumentenlenkung

Fragen und Antworten

Prüfmittel

Material

Mitarbeiterschulungen

8D-Report

Sonstiges

PDF-Vorlagen

Lieferantenbewertung

Dateiverwaltung

Prozesse