Mercurial > gemma

comparison report-templates/data-quality-report.yaml @ 5646:88fdf143daf1 DQR adjustments

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
finalize report
author Thomas Junk <thomas.junk@intevation.de>
date Mon, 19 Jun 2023 17:21:45 +0200
parents f432f578d7e7
children e8aa69040bec
comparison
equal deleted inserted replaced
5645:6fe970d800ec 5646:88fdf143daf1
15 - type: copy 15 - type: copy
16 location: [A1, A5] 16 location: [A1, A5]
17 # BN names 17 # BN names
18 - type: select 18 - type: select
19 statement: > 19 statement: >
20 SELECT DISTINCT bottleneck_id, objnam AS bnnam, hm 20 SELECT DISTINCT bottleneck_id, concat(bottleneck_id, ' (', objnam, ')') AS bnnam, hm
21 FROM waterway.dqr_bottleneck_stats 21 FROM waterway.dqr_bottleneck_stats
22 WHERE cc = {{ cc }} ORDER BY hm, bottleneck_id, objnam; 22 WHERE cc = {{ cc }} ORDER BY hm, bottleneck_id;
23 actions: 23 actions:
24 - type: assign 24 - type: assign
25 name: last_row 25 name: last_row
26 expr: (row_number ?? 0) + 6 26 expr: (row_number ?? 0) + 6
27 - type: copy 27 - type: copy
47 location: [B4, C5] 47 location: [B4, C5]
48 destination: "{{ coord2cell(column_number, 4) }}" 48 destination: "{{ coord2cell(column_number, 4) }}"
49 # BN SR-Count 49 # BN SR-Count
50 - type: select 50 - type: select
51 statement: > 51 statement: >
52 SELECT concat(bottleneck_id, ' ', objnam), srcnt, fwacnt 52 SELECT concat(bottleneck_id, ' (', objnam, ')') AS objnam, srcnt, fwacnt
53 FROM waterway.dqr_bottleneck_stats 53 FROM waterway.dqr_bottleneck_stats
54 WHERE cc = {{ cc }} AND month = {{ d }} 54 WHERE cc = {{ cc }} AND month = {{ d }}
55 ORDER BY hm, bottleneck_id; 55 ORDER BY hm, bottleneck_id;
56 actions: 56 actions:
57 - type: assign 57 - type: assign