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;