changeset 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
files gnv-artifacts/ChangeLog gnv-artifacts/src/test/ressources/conf.xml gnv-artifacts/src/test/ressources/queries.properties
diffstat 3 files changed, 14 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/gnv-artifacts/ChangeLog	Tue Oct 13 10:17:46 2009 +0000
+++ b/gnv-artifacts/ChangeLog	Tue Oct 13 10:30:01 2009 +0000
@@ -1,3 +1,9 @@
+2009-10-13  Tim Englich  <tim.englich@intevation.de>
+
+	* src/test/ressources/queries.properties,
+	  src/test/ressources/conf.xml:
+	  Added Parameter-Usage in Time-Interval-Query ISSUE-33
+
 2009-10-13  Tim Englich  <tim.englich@intevation.de>
 
 	* src/test/ressources/verticalprofile_mesh/verticalprofile_step_*_feed.xml, 
--- a/gnv-artifacts/src/test/ressources/conf.xml	Tue Oct 13 10:17:46 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/conf.xml	Tue Oct 13 10:30:01 2009 +0000
@@ -243,7 +243,7 @@
                          <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/>
                          <inputvalue name="measurementid" type="Integer" multiselect="false" usedinquery="0"/>
                          <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/>
-                         <inputvalue name="parameterid"   type="Integer" multiselect="true" usedinquery="0"/>
+                         <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/>
                     </inputvalues>
                 </transition>
                 
@@ -252,7 +252,7 @@
                     <inputvalues>
                         <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/>
                          <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="1"/>
-                         <inputvalue name="parameterid"   type="Integer" multiselect="true" usedinquery="1"/>
+                         <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1"/>
                          <inputvalue name="measurementid" type="Integer" multiselect="false" usedinquery="1"/>
                          <inputvalue name="minvalue" type="Date" multiselect="false" usedinquery="1"/>
                          <inputvalue name="maxvalue" type="Date" multiselect="false" usedinquery="1"/>
@@ -302,7 +302,10 @@
                     <inputvalues>
                         <inputvalue name="featureid" type="Integer" multiselect="false"/>
                     </inputvalues>
-                </transition>
+                </transition>           
+           
+           
+           
                 
                  <transition id="timeseries_depth_height" description="timeseries_depth_height" transition="de.intevation.gnv.transition.DefaultTransition">
                     <queryID>timeseries_depth_height</queryID>
--- 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