Mercurial > gemma

changeset 2770:ab1a22052437

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Handle the case of missing depth references for bottlenecks gracefully.
author Sascha Wilde <wilde@intevation.de>
date Fri, 22 Mar 2019 11:25:09 +0100
parents c2a2515c7a72
children 838cf903538f 0f467af6bf5c
files schema/gemma.sql
diffstat 1 files changed, 3 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Mar 22 11:06:15 2019 +0100
+++ b/schema/gemma.sql	Fri Mar 22 11:25:09 2019 +0100
@@ -628,7 +628,9 @@
         b.source_organization,
         g.location AS gauge_isrs_code,
         g.objname AS gauge_objname,
-        json_object_agg(r.depth_reference, r.value) AS reference_water_levels,
+        json_strip_nulls(json_object_agg(coalesce(r.depth_reference,'empty'),
+                                                  r.value))
+            AS reference_water_levels,
         fal.date_info AS fa_date_info,
         fal.critical AS fa_critical,
         gmw.water_level as gm_waterlevel