# HG changeset patch
# User Raimund Renkert <raimund.renkert@intevation.de>
# Date 1348477842 0
# Node ID 729bd242c82e933e95785de26c7c182325649852
# Parent  bdf855b5693f0755556ed8050a7bf75ff60ce753
MINFO: Fixed SQL statement in BedloadOverview. Exclude data where km is null.



flys-artifacts/trunk@5584 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r bdf855b5693f -r 729bd242c82e flys-artifacts/ChangeLog
--- 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:
diff -r bdf855b5693f -r 729bd242c82e flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.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";