Mercurial > dive4elements > river
changeset 6275:2d495b504c74
Order bed heights by station.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Tue, 11 Jun 2013 14:58:13 +0200 |
| parents | 24be0cc1c67c |
| children | 0a6e486e21c4 |
| files | artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java |
| diffstat | 1 files changed, 5 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java Tue Jun 11 12:57:51 2013 +0200 +++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java Tue Jun 11 14:58:13 2013 +0200 @@ -33,7 +33,9 @@ "SELECT bhsv.height, bhsv.station, bhsv.data_gap, bhsv.sounding_width, bhs.year " + " FROM bed_height_single bhs" + " JOIN bed_height_single_values bhsv on bhsv.bed_height_single_id = bhs.id" + - " WHERE bhs.id = :height_id"; + " WHERE bhs.id = :height_id" + + " ORDER BY bhsv.station"; + /** Query to get name for wst_id and column_pos. */ public static final String SQL_SELECT_EPOCH = @@ -41,7 +43,8 @@ " FROM bed_height_epoch b" + " JOIN bed_height_epoch_values bv ON b.id = bv.bed_height_epoch_id" + " JOIN time_intervals ti ON b.time_interval_id = ti.id" + - " WHERE b.id = :height_id"; + " WHERE b.id = :height_id" + + " ORDER BY bhsv.station"; /** Query to get name (description) for wst_id. */ public static final String SQL_SELECT_DESCR_SINGLE =