changeset 3725:18777f6df3ef

Partially fix waterlevel selection for gauge_measurements(_predictions)
author Raimund Renkert <raimund.renkert@intevation.de>
date Thu, 20 Jun 2019 18:42:52 +0200
parents 05bbd1a97567
children be939dcdfdfd
files pkg/controllers/gauges.go
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/gauges.go	Thu Jun 20 18:36:53 2019 +0200
+++ b/pkg/controllers/gauges.go	Thu Jun 20 18:42:52 2019 +0200
@@ -663,6 +663,7 @@
 		return
 	}
 
+	// TODO: FIXME The filter is not correct for predictions!?
 	filters := filterAnd{
 		buildFilterTerm(
 			"location = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int)",
@@ -677,7 +678,7 @@
 			buildFilterTerm(
 				`date_issue = (
                  SELECT max(date_issue)
-                 FROM waterway.gauge_measurements gm
+                 FROM waterway.gauge_predictions gm
                  WHERE location = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int))`,
 				isrs.CountryCode,
 				isrs.LoCode,