Mercurial > gemma
changeset 5648:e8aa69040bec DQR adjustments
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
--- 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: