Mercurial > dive4elements > river
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;