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 Linksamples.id
= Part of the linksamples.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