Mercurial > gemma

comparison pkg/controllers/surveys.go @ 4159:80e9cfb2be98

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed duplicates in list surveys endpoint.
author Sascha Wilde <wilde@intevation.de>
date Fri, 02 Aug 2019 16:37:24 +0200
parents 02d5c2e17eb8
children 1458c9b0fdaa
comparison
equal deleted inserted replaced
4158:5466562cca60 4159:80e9cfb2be98
36 JOIN waterway.gauges AS g 36 JOIN waterway.gauges AS g
37 ON b.gauge_location = g.location AND s.date_info::timestamptz <@ g.validity 37 ON b.gauge_location = g.location AND s.date_info::timestamptz <@ g.validity
38 LEFT JOIN waterway.gauges_reference_water_levels AS r 38 LEFT JOIN waterway.gauges_reference_water_levels AS r
39 ON s.depth_reference = r.depth_reference 39 ON s.depth_reference = r.depth_reference
40 AND g.location = r.location AND g.validity = r.validity 40 AND g.location = r.location AND g.validity = r.validity
41 WHERE b.objnam = $1` 41 WHERE b.objnam = $1 AND s.date_info::timestamptz <@ b.validity`
42 ) 42 )
43 43
44 func listSurveys( 44 func listSurveys(
45 _ interface{}, 45 _ interface{},
46 req *http.Request, 46 req *http.Request,