LIMS.eu

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;