Mercurial > gemma

changeset 5644:f432f578d7e7 DQR adjustments

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
WIP
author Thomas Junk <thomas.junk@intevation.de>
date Wed, 14 Jun 2023 10:14:43 +0200
parents b4ee50490592
children 6fe970d800ec
files report-templates/data-quality-report.yaml
diffstat 1 files changed, 4 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- 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