Mercurial > dive4elements > river
diff flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java @ 3287:30f157c7e466
SQ: Filter out meassures which don't have a 'Siebsatz'
flys-artifacts/trunk@4953 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 12 Jul 2012 13:58:30 +0000 |
parents | 4903e491992e |
children | ec9aab93f292 |
line wrap: on
line diff
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java Thu Jul 12 11:51:32 2012 +0000 +++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java Thu Jul 12 13:58:30 2012 +0000 @@ -91,13 +91,14 @@ " m.datum AS datum " + "FROM messung m " + " JOIN station s" + - " on m.stationid = s.stationid " + + " ON m.stationid = s.stationid " + " JOIN gewaesser g " + - " on s.gewaesserid = g.gewaesserid " + + " ON s.gewaesserid = g.gewaesserid " + "WHERE" + + " m.gsiebsatzid IS NOT NULL AND" + " g.name = :name " + - " order by" + - " s.km, m.datum"; + "ORDER by" + + " s.km, m.datum"; protected String riverName;