# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1379315853 -7200
# Node ID b9633d6ce57e16f3f5172ef1ee3d4ad0be00d775
# Parent  a9ff696c2d18acd997f94bc88d28c505940d3b49
issue1157: Fix sorting by start time (descending) for cross-section selection.

diff -r a9ff696c2d18 -r b9633d6ce57e backend/src/main/java/org/dive4elements/river/model/CrossSection.java
--- a/backend/src/main/java/org/dive4elements/river/model/CrossSection.java	Fri Sep 13 17:42:09 2013 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/CrossSection.java	Mon Sep 16 09:17:33 2013 +0200
@@ -69,7 +69,7 @@
         "JOIN cross_sections cs ON cs_ranges.cross_section_id = cs.id " +
         "LEFT OUTER JOIN time_intervals ON cs.time_interval_id = time_intervals.id " +
         "WHERE :km BETWEEN minkm AND maxkm " +
-        "ORDER BY stop_time desc, start_time asc, :km - minkm";
+        "ORDER BY stop_time desc, start_time desc, :km - minkm";
     // Order by time interval missing.
 
     private Integer                id;