Mercurial > gemma

changeset 5648:e8aa69040bec DQR adjustments

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapt column width in report template. Switch bnid (objnam) to objnam (bnid) in report
author Thomas Junk <thomas.junk@intevation.de>
date Wed, 28 Jun 2023 16:56:36 +0200
parents 2a1f36ab6e91
children 210367364f5b
files report-templates/data-quality-report.xlsx report-templates/data-quality-report.yaml
diffstat 2 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
Binary file report-templates/data-quality-report.xlsx has changed
--- a/report-templates/data-quality-report.yaml	Tue Jun 20 12:04:52 2023 +0200
+++ b/report-templates/data-quality-report.yaml	Wed Jun 28 16:56:36 2023 +0200
@@ -17,7 +17,7 @@
           # BN names
           - type: select
             statement: >
-              SELECT DISTINCT bottleneck_id, concat(bottleneck_id, ' (', objnam, ')') AS bnnam, hm
+              SELECT DISTINCT bottleneck_id, concat(objnam, ' (', bottleneck_id, ')') AS bnnam, hm
                 FROM waterway.dqr_bottleneck_stats
                 WHERE cc = {{ cc }} ORDER BY hm, bottleneck_id;
             actions: