Mercurial > dive4elements > river
diff artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadDataFactory.java @ 8047:c835f3cf098e
Sediment load: Added join to fetch measurement station via ranges which know the river. Added a visitor for values, too.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 17 Jul 2014 11:19:59 +0200 |
parents | 3a769d5fb733 |
children | cd35b76f1ef8 |
line wrap: on
line diff
--- a/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadDataFactory.java Thu Jul 17 10:56:38 2014 +0200 +++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadDataFactory.java Thu Jul 17 11:19:59 2014 +0200 @@ -45,7 +45,8 @@ "JOIN time_intervals ti ON sl.time_interval_id = ti.id " + "JOIN grain_fraction gf ON sl.grain_fraction_id = gf.id " + "JOIN measurement_station ms ON slv.measurement_station_id = ms.id " + - "JOIN rivers r ON ms.river_id = r.id " + + "JOIN ranges rng ON ms.range_id = rng.id " + + "JOIN rivers r ON rng.river_id = r.id " + "WHERE r.name = :river " + "ORDER BY sl.id";