changeset 6358:e1093f75a36f

Order bed quality data by km.
author Raimund Renkert <rrenkert@intevation.de>
date Tue, 18 Jun 2013 09:09:42 +0200
parents 673e146e7793
children e2b1057cee04
files artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java
diffstat 1 files changed, 4 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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 {

http://dive4elements.wald.intevation.org