# HG changeset patch
# User mschaefer
# Date 1528095018 -7200
# Node ID bfc0da2aa3aa31954cf836861de22264d6746e4b
# Parent  189cc8ededbd4f04ecbd04c0854a7473e5b27cd4
Where clause of the predefined datacage series extended by km range condition

diff -r 189cc8ededbd -r bfc0da2aa3aa artifacts/doc/conf/meta-data.xml
--- a/artifacts/doc/conf/meta-data.xml	Mon Jun 04 08:36:09 2018 +0200
+++ b/artifacts/doc/conf/meta-data.xml	Mon Jun 04 08:50:18 2018 +0200
@@ -3465,6 +3465,7 @@
           INNER JOIN tkh_values v ON sc.id=v.tkh_column_id
           WHERE (s.river_id=${river_id})
           AND (lower(s.groupname)=${tkh_groupname})
+          AND (v.station BETWEEN ${fromkm}-0.0001 AND ${tokm}+0.0001)
           GROUP BY sc.tkh_id, sc.id
           ORDER BY sc.id
         </dc:statement>
@@ -3507,6 +3508,7 @@
           FROM depth_evolution s INNER JOIN depth_evolution_values v ON s.id=v.depth_evolution_id
           WHERE (s.river_id=${river_id})
           AND (lower(s.groupname)=${depthevol_groupname})
+          AND (v.station BETWEEN ${fromkm}-0.0001 AND ${tokm}+0.0001)
           GROUP BY s.id
           ORDER BY s.id
         </dc:statement>
@@ -3533,6 +3535,7 @@
           FROM flow_depth_column sc INNER JOIN flow_depth s ON sc.flow_depth_id=s.id
           INNER JOIN flow_depth_values v ON sc.id=v.flow_depth_column_id
           WHERE (s.river_id=${river_id})
+          AND (v.station BETWEEN ${fromkm}-0.0001 AND ${tokm}+0.0001)
           GROUP BY sc.flow_depth_id, sc.id
           ORDER BY sc.id
         </dc:statement>