Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 6269:5b1cc816fcdb | 6270:44ee7d26eb18 |
|---|---|
| 49 "SELECT km, x, y, csl.id AS csl_id " + | 49 "SELECT km, x, y, csl.id AS csl_id " + |
| 50 "FROM cross_section_lines csl JOIN cross_section_points csp " + | 50 "FROM cross_section_lines csl JOIN cross_section_points csp " + |
| 51 "ON csp.cross_section_line_id = csl.id " + | 51 "ON csp.cross_section_line_id = csl.id " + |
| 52 "WHERE csl.cross_section_id = :cs_id AND " + | 52 "WHERE csl.cross_section_id = :cs_id AND " + |
| 53 "km between :from_km AND :to_km " + | 53 "km between :from_km AND :to_km " + |
| 54 "ORDER BY csl.id, csp.col_pos"; | 54 "ORDER BY csl.km, csl.id, csp.col_pos"; |
| 55 | 55 |
| 56 private Integer id; | 56 private Integer id; |
| 57 private River river; | 57 private River river; |
| 58 private TimeInterval timeInterval; | 58 private TimeInterval timeInterval; |
| 59 private String description; | 59 private String description; |