diff gnv-artifacts/src/test/ressources/queries.properties @ 170:7be22e76c270

Added parameter to the DateQueroes of Meshes gnv-artifacts/trunk@207 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 09 Oct 2009 07:49:47 +0000
parents 5134266f00e7
children 1b2fc94766c9
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties	Wed Oct 07 13:29:15 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/queries.properties	Fri Oct 09 07:49:47 2009 +0000
@@ -256,7 +256,8 @@
          MEDIAN.MESH m \
     where m.OBJECTID = ?  AND \
           msv.PARTID >= m.PARTIDMIN AND \
-          msv.PARTID <= m.PARTIDMAX \
+          msv.PARTID <= m.PARTIDMAX AND \
+          msv.PARAMETERID in (?) \
     order by msv.TIMEVALUE
 
 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \

http://dive4elements.wald.intevation.org