# HG changeset patch
# User Raimund Renkert <rrenkert@intevation.de>
# Date 1371539382 -7200
# Node ID e1093f75a36f560c48b82b58f26f9e9caa395564
# Parent  673e146e779378b79757e7d24027bcc80b35508f
Order bed quality data by km.

diff -r 673e146e7793 -r e1093f75a36f artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java
--- a/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java	Tue Jun 18 09:09:08 2013 +0200
+++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java	Tue Jun 18 09:09:42 2013 +0200
@@ -55,7 +55,8 @@
         "      sp.tiefevon IS NOT NULL AND " +
         "      sp.tiefebis IS NOT NULL AND " + // TODO: Test if char diameter ist null.
         "      st.km BETWEEN :from - 0.001 AND :to + 0.001 AND " +
-        "      st.datum BETWEEN :start AND :end";
+        "      st.datum BETWEEN :start AND :end " +
+        "ORDER BY st.km";
 
     private static final String SQL_BEDLOAD_MEASUREMENT =
         "SELECT m.km    as km," +
@@ -82,7 +83,8 @@
         "      m.km IS NOT NULL AND " +
         "      m.d10 IS NOT NULL AND" + //TODO: Add all other char. diameter.
         "      m.km BETWEEN :from - 0.001 AND :to + 0.001 AND" +
-        "      m.datum BETWEEN :start AND :end";
+        "      m.datum BETWEEN :start AND :end " +
+        "ORDER BY m.km";
 
     public static final class QualityMeasurementResultTransformer
     extends BasicTransformerAdapter {