changeset 6650:531642542b18

fixed statement for floodplains in datacage-config (with Andre's eyes)
author Tom Gottfried <tom@intevation.de>
date Wed, 24 Jul 2013 17:24:02 +0200
parents 5e567047ef72
children ca80f61370ab
files artifacts/doc/conf/meta-data.xml
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/artifacts/doc/conf/meta-data.xml	Wed Jul 24 10:50:43 2013 +0200
+++ b/artifacts/doc/conf/meta-data.xml	Wed Jul 24 17:24:02 2013 +0200
@@ -1920,10 +1920,10 @@
           SELECT DISTINCT
             fp.kind_id AS kind_id,
             flk.name AS kind_name
+            fp.name AS layer_name
           FROM floodplain fp
             JOIN floodplain_kinds flk on fp.kind_id = flk.id
           WHERE river_id = ${river_id}
-            AND kind_id=1
         </dc:statement>
         <dc:if test="dc:has-result()">
           <floodplain>

http://dive4elements.wald.intevation.org