# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1255074587 0
# Node ID 7be22e76c270cffd4a800ce8c9e963907c88a6fb
# Parent  cfaaa215d8ffdbb202416822aef80b95c9d3888e
Added parameter to the DateQueroes of Meshes

gnv-artifacts/trunk@207 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r cfaaa215d8ff -r 7be22e76c270 gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Wed Oct 07 13:29:15 2009 +0000
+++ b/gnv-artifacts/ChangeLog	Fri Oct 09 07:49:47 2009 +0000
@@ -1,3 +1,11 @@
+2009-10-09  Tim Englich  <tim.englich@intevation.de>
+
+	* src/test/ressources/queries.properties Edited:
+	  Add Parameters to the Queries to select only the Dates where
+	  the Parameters has been measured. 
+	* src/test/ressources/conf.xml Edited:
+	  Set that the ParameterIds should be used in the Query of the Dates. 
+
 2009-10-07	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	RELEASE 0.1
diff -r cfaaa215d8ff -r 7be22e76c270 gnv-artifacts/src/test/ressources/conf.xml
--- a/gnv-artifacts/src/test/ressources/conf.xml	Wed Oct 07 13:29:15 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/conf.xml	Fri Oct 09 07:49:47 2009 +0000
@@ -479,7 +479,7 @@
                     <inputvalues>
                         <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/>
                         <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/>
-                        <inputvalue name="parameterid" type="Integer" multiselect="true"/>
+                        <inputvalue name="parameterid" type="Integer" multiselect="true" usedinquery="1" />
                     </inputvalues>
                 </transition>
                 
@@ -764,7 +764,7 @@
                         <inputvalue name="meshid" type="Integer" multiselect="false" usedinquery="1"/>
                         <inputvalue name="mesh_point" type="Integer" multiselect="false" usedinquery="0"/>
                         <inputvalue name="axisid" type="AttributeName" multiselect="false" usedinquery="0"/>
-                        <inputvalue name="parameterid" type="Integer" multiselect="true"  usedinquery="0"/>
+                        <inputvalue name="parameterid" type="Integer" multiselect="true"  usedinquery="1"/>
                         <inputvalue name="depthid" type="Integer" multiselect="true"  usedinquery="0"/>
                     </inputvalues>
                 </transition>
diff -r cfaaa215d8ff -r 7be22e76c270 gnv-artifacts/src/test/ressources/queries.properties
--- 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, \