Mercurial > gemma

diff report-templates/data-quality-report.yaml @ 5401:fbad74acd23f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Sort BN and WG in reports by river hectometre.
author Sascha Wilde <wilde@sha-bang.de>
date Wed, 07 Jul 2021 20:11:17 +0200
parents 014dc3219bdb
children 5be842692d87
line wrap: on
line diff
--- a/report-templates/data-quality-report.yaml	Wed Jul 07 18:41:53 2021 +0200
+++ b/report-templates/data-quality-report.yaml	Wed Jul 07 20:11:17 2021 +0200
@@ -17,9 +17,9 @@
     # BN names
     - type: select
       statement: >
-        SELECT DISTINCT objnam AS bnnam
+        SELECT DISTINCT objnam AS bnnam, hm 
           FROM waterway.dqr_bottleneck_stats
-          WHERE cc = {{ cc }} ORDER BY objnam;
+          WHERE cc = {{ cc }} ORDER BY hm, objnam;
       actions:
       - type: assign
         name: last_row
@@ -50,7 +50,7 @@
           SELECT objnam, srcnt, fwacnt
             FROM waterway.dqr_bottleneck_stats
             WHERE cc = {{ cc }} AND month = {{ d }}
-            ORDER BY objnam;
+            ORDER BY hm, objnam;
         actions:
         - type: assign
           name: last_row
@@ -73,8 +73,8 @@
     # Gauges names
     - type: select
       statement: >
-        SELECT DISTINCT objname AS gnam FROM waterway.dqr_gauge_stats
-          WHERE cc = {{ cc }} ORDER BY objname;
+        SELECT DISTINCT objname AS gnam, hm FROM waterway.dqr_gauge_stats
+          WHERE cc = {{ cc }} ORDER BY hm, objname;
       actions:
       - type: assign
         name: last_row
@@ -105,7 +105,7 @@
           SELECT objname, daynodata
             FROM waterway.dqr_gauge_stats
             WHERE cc = {{ cc }} AND month = {{ d }}
-            ORDER BY objname;
+            ORDER BY hm, objname;
         actions:
         - type: assign
           name: last_row