Mercurial > gemma

diff schema/gemma.sql @ 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 41f5ac76d642
children a2127495093e
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