changeset 7195:c0349b54c604

issue1435: Remove hardcoded river for dc sediment yield sql query.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Fri, 27 Sep 2013 22:09:12 +0200
parents 5be5bf32bead
children e6f9c831a75f
files artifacts/doc/conf/meta-data.xml
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/artifacts/doc/conf/meta-data.xml	Fri Sep 27 16:17:03 2013 +0200
+++ b/artifacts/doc/conf/meta-data.xml	Fri Sep 27 22:09:12 2013 +0200
@@ -1242,7 +1242,7 @@
                 JOIN rivers r ON sy.river_id = r.id
                 JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id
                 JOIN time_intervals ti ON sy.time_interval_id = ti.id
-            WHERE   r.name = 'Elbe'
+            WHERE   r.id = ${river_id}
                 AND ti.stop_time IS NULL
                 AND syv.station BETWEEN ${fromkm} AND ${tokm}
         </dc:statement>
@@ -1268,7 +1268,7 @@
                 JOIN rivers r ON sy.river_id = r.id
                 JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id
                 JOIN time_intervals ti ON sy.time_interval_id = ti.id
-            WHERE   r.name = 'Elbe'
+            WHERE   r.id = ${river_id}
                 AND ti.stop_time IS NOT NULL
                 AND syv.station BETWEEN ${fromkm} AND ${tokm}
         </dc:statement>

http://dive4elements.wald.intevation.org