# HG changeset patch
# User Thomas Junk <thomas.junk@intevation.de>
# Date 1686730483 -7200
# Node ID f432f578d7e793130e5041b23cc7dd5d666f22f0
# Parent  b4ee504905928ec20d908778520cc6e5bb2fa063
WIP

diff -r b4ee50490592 -r f432f578d7e7 report-templates/data-quality-report.yaml
--- a/report-templates/data-quality-report.yaml	Wed Jun 14 10:08:25 2023 +0200
+++ b/report-templates/data-quality-report.yaml	Wed Jun 14 10:14:43 2023 +0200
@@ -17,9 +17,9 @@
           # BN names
           - type: select
             statement: >
-              SELECT DISTINCT objnam AS bnnam, hm
+              SELECT DISTINCT bottleneck_id, objnam AS bnnam, hm
                 FROM waterway.dqr_bottleneck_stats
-                WHERE cc = {{ cc }} ORDER BY hm, objnam;
+                WHERE cc = {{ cc }} ORDER BY hm, bottleneck_id, objnam;
             actions:
               - type: assign
                 name: last_row
@@ -49,10 +49,10 @@
               # BN SR-Count
               - type: select
                 statement: >
-                  SELECT objnam, srcnt, fwacnt
+                  SELECT concat(bottleneck_id, ' ', objnam), srcnt, fwacnt
                     FROM waterway.dqr_bottleneck_stats
                     WHERE cc = {{ cc }} AND month = {{ d }}
-                    ORDER BY hm, objnam;
+                    ORDER BY hm, bottleneck_id;
                 actions:
                   - type: assign
                     name: last_row