diff backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 6270:44ee7d26eb18

issue1267: Polishing: Move the sorting into the db/sql-query.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Tue, 11 Jun 2013 12:19:01 +0200
parents 5b1cc816fcdb
children c155f8f57b7e
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/model/CrossSection.java	Tue Jun 11 12:05:01 2013 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/CrossSection.java	Tue Jun 11 12:19:01 2013 +0200
@@ -51,7 +51,7 @@
         "ON csp.cross_section_line_id = csl.id " +
         "WHERE csl.cross_section_id = :cs_id AND " +
         "km between :from_km AND :to_km " +
-        "ORDER BY csl.id, csp.col_pos";
+        "ORDER BY csl.km, csl.id, csp.col_pos";
 
     private Integer                id;
     private River                  river;

http://dive4elements.wald.intevation.org