changeset 7017:b9633d6ce57e

issue1157: Fix sorting by start time (descending) for cross-section selection.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Mon, 16 Sep 2013 09:17:33 +0200
parents a9ff696c2d18
children acb63fd3c8d3
files backend/src/main/java/org/dive4elements/river/model/CrossSection.java
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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;

http://dive4elements.wald.intevation.org