diff gnv-artifacts/src/test/ressources/queries.properties @ 175:14263534255b

Added Parameter-Usage in Time-Interval-Query ISSUE-33 gnv-artifacts/trunk@214 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 13 Oct 2009 10:30:01 +0000
parents dbf68950b4d9
children bff7bbb7c6f0
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties	Tue Oct 13 10:17:46 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/queries.properties	Tue Oct 13 10:30:01 2009 +0000
@@ -137,7 +137,8 @@
          MEDIAN.MESH m \
     where m.OBJECTID = ? AND \
           msc.PARTID >= m.PARTIDMIN AND \
-          msc.PARTID <= m.PARTIDMAX
+          msc.PARTID <= m.PARTIDMAX AND \
+          msc.PARAMETERID IN (?)
 
 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \
         msv.TIMEVALUE XORDINATE, \

http://dive4elements.wald.intevation.org