Mercurial > dive4elements > river
changeset 3914:729bd242c82e
MINFO: Fixed SQL statement in BedloadOverview. Exclude data where km is null.
flys-artifacts/trunk@5584 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 24 Sep 2012 09:10:42 +0000 |
| parents | bdf855b5693f |
| children | 36107252e9ef |
| files | flys-artifacts/ChangeLog flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java |
| diffstat | 2 files changed, 7 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-artifacts/ChangeLog Mon Sep 24 08:36:33 2012 +0000 +++ b/flys-artifacts/ChangeLog Mon Sep 24 09:10:42 2012 +0000 @@ -1,3 +1,8 @@ +2012-09-21 Raimund Renkert <raimund.renkert@intevation.de> + + * src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java: + Fixed SQL statement. Exclude data where km is null. + 2012-09-24 Christian Lins <christian.lins@intevation.de> * src/main/java/de/intevation/flys/artifacts/states/fixation/FixAnalysisCompute.java:
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java Mon Sep 24 08:36:33 2012 +0000 +++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java Mon Sep 24 09:10:42 2012 +0000 @@ -85,7 +85,8 @@ " JOIN gewaesser g " + " ON s.gewaesserid = g.gewaesserid " + "WHERE" + - " g.name = :name " + + " g.name = :name AND " + + " m.km IS NOT NULL " + "ORDER by" + " m.km, m.datum";