diff options
| author | Paul-Christian Volkmer | 2023-03-27 08:50:37 +0200 |
|---|---|---|
| committer | Paul-Christian Volkmer | 2023-03-27 08:50:37 +0200 |
| commit | 46d68923597d065474421bb92a7074d7273bf37d (patch) | |
| tree | 604c39a448eb39ea86b3d996f4022f69302e1330 /src/main/java | |
| parent | 9e56a52ac8b0a6a0d3338dc883b93c3d670bd39c (diff) | |
| parent | 26041475f80f2288474d7c5d08bd7fdc941d90f2 (diff) | |
Merge branch '0.1.x'
Diffstat (limited to 'src/main/java')
| -rw-r--r-- | src/main/java/DNPM/DNPMHelper.java | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/main/java/DNPM/DNPMHelper.java b/src/main/java/DNPM/DNPMHelper.java index 6e34a33..828546f 100644 --- a/src/main/java/DNPM/DNPMHelper.java +++ b/src/main/java/DNPM/DNPMHelper.java @@ -199,10 +199,10 @@ public class DNPMHelper implements IProcedureAnalyzer { try { SessionFactory sessionFactory = onkostarApi.getSessionFactory(); Session session = sessionFactory.getCurrentSession(); - var sql = "SELECT * FROM prozedur " + var sql = "SELECT prozedur.id, genname, geneid, geneidlink, empfehlung, beginndatum FROM prozedur " + "LEFT JOIN dk_mtb_einzelempfehlung em ON em.id = prozedur.id " - // TODO data_form_id immer 489? - + "WHERE prozedur.hauptprozedur_id = " + Integer.parseInt(procedureID.toString()) + " AND prozedur.geloescht = 0 AND prozedur.data_form_id = 489 " + + "JOIN data_form df ON prozedur.data_form_id = df.id AND df.name = 'MR.MTB_Einzelempfehlung' " + + "WHERE prozedur.hauptprozedur_id = " + Integer.parseInt(procedureID.toString()) + " AND prozedur.geloescht = 0 " + "ORDER BY beginndatum"; SQLQuery query = session.createSQLQuery(sql) |