Mercurial > dive4elements > gnv-client
changeset 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 | cfaaa215d8ff |
| children | 7fb9441dd8af |
| files | gnv-artifacts/ChangeLog gnv-artifacts/src/test/ressources/conf.xml gnv-artifacts/src/test/ressources/queries.properties |
| diffstat | 3 files changed, 12 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- 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
--- 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>
--- 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, \