Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 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 | d02ad36115c6 |
| children | 9d2e69f971f5 |
comparison
equal
deleted
inserted
replaced
| 7015:a9ff696c2d18 | 7017:b9633d6ce57e |
|---|---|
| 67 " GROUP BY cross_section_id" + | 67 " GROUP BY cross_section_id" + |
| 68 ") cs_ranges " + | 68 ") cs_ranges " + |
| 69 "JOIN cross_sections cs ON cs_ranges.cross_section_id = cs.id " + | 69 "JOIN cross_sections cs ON cs_ranges.cross_section_id = cs.id " + |
| 70 "LEFT OUTER JOIN time_intervals ON cs.time_interval_id = time_intervals.id " + | 70 "LEFT OUTER JOIN time_intervals ON cs.time_interval_id = time_intervals.id " + |
| 71 "WHERE :km BETWEEN minkm AND maxkm " + | 71 "WHERE :km BETWEEN minkm AND maxkm " + |
| 72 "ORDER BY stop_time desc, start_time asc, :km - minkm"; | 72 "ORDER BY stop_time desc, start_time desc, :km - minkm"; |
| 73 // Order by time interval missing. | 73 // Order by time interval missing. |
| 74 | 74 |
| 75 private Integer id; | 75 private Integer id; |
| 76 private River river; | 76 private River river; |
| 77 private TimeInterval timeInterval; | 77 private TimeInterval timeInterval; |