Changes between Version 4 and Version 5 of AdvancedQueries

Timestamp:

08/25/25 13:18:05 (8 days ago)

Author:

221007

Comment:

--

AdvancedQueries

@@ -295 +295 @@
              join medicalreport_diagnosis mrd on mrd.report_id = r.report_id
              join diagnosis d on mrd.diagnosis_id = d.diagnosis_id
-    where p.person_id = 14 --parameter (the most of them are person_id = 1)
+    where p.person_id = :person_id
 )
 select cast(p2.person_id as bigint),
@@ -305 +305 @@
          join report r2 on r2.report_id = mrd2.report_id
          join person p2 on p2.person_id = r2.person_id
-where p2.person_id != 14 --parameter of the person
+where p2.person_id != :person_id
 group by p2.person_id, p2.name, p2.surname
 having count(distinct spd.diagnosis_id) >=1