Mercurial > gemma
diff pkg/controllers/gauges.go @ 2817:ff58440ce809
Added staging_done to the longterm waterlevels selections.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 27 Mar 2019 10:19:31 +0100 |
parents | 6f435a9558f2 |
children | f7ae108c2838 |
line wrap: on
line diff
--- a/pkg/controllers/gauges.go Tue Mar 26 19:37:55 2019 +0100 +++ b/pkg/controllers/gauges.go Wed Mar 27 10:19:31 2019 +0100 @@ -85,7 +85,7 @@ min(water_level) AS min, max(water_level) AS max FROM waterway.gauge_measurements, g -WHERE fk_gauge_id = g.loc AND NOT predicted +WHERE fk_gauge_id = g.loc AND NOT predicted AND staging_done GROUP BY extract(day from measure_date)::varchar || ':' || extract(month from measure_date)::varchar; ` @@ -95,8 +95,9 @@ water_level FROM waterway.gauge_measurements WHERE - NOT predicted - AND fk_gauge_id = ( + NOT predicted AND + staging_done AND + fk_gauge_id = ( $1::char(2), $2::char(3), $3::char(5),