# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1268745044 0
# Node ID 686eecfafbbf092eaadd77a41df850d60ba04c1b
# Parent  5b9945798f86d1d6389d39c25e3a142fca77b887
Bugfixes: Fixed the Query for Parameters in Timeseries and VerticalProfiles in Meshes.

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

diff -r 5b9945798f86 -r 686eecfafbbf gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Tue Mar 16 13:06:53 2010 +0000
+++ b/gnv-artifacts/ChangeLog	Tue Mar 16 13:10:44 2010 +0000
@@ -1,3 +1,10 @@
+2010-03-16  Tim Englich  <tim.englich@intevation.de>
+
+	* doc/conf/queries.properties: 
+	  Bugfixes: Fixed the Query for Parameters in Timeseries and 
+	  VerticalProfiles in Meshes. Now all Parts of an Mesh will be used and not 
+	  only the last one.
+
 2010-03-16  Tim Englich  <tim.englich@intevation.de>
 
 	* doc/conf/products/timeseries/conf_mesh.xml,
diff -r 5b9945798f86 -r 686eecfafbbf gnv-artifacts/doc/conf/queries.properties
--- a/gnv-artifacts/doc/conf/queries.properties	Tue Mar 16 13:06:53 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Tue Mar 16 13:10:44 2010 +0000
@@ -164,7 +164,7 @@
     from MEDIAN.PARAMETER p, \
          MEDIAN.MESHSCALARVALUE msc, \
          MEDIAN.MESH m \
-   where m.OBJECTID = ? AND \ 
+   where m.OBJECTID = ? AND \
           msc.PARTID >= m.PARTIDMIN AND \
           msc.PARTID <= m.PARTIDMAX AND \
           msc.PARAMETERID = p.PARAMETERID \
@@ -430,7 +430,8 @@
          MEDIAN.MESHSCALARVALUE msc, \
          MEDIAN.MESH m  \
     where m.OBJECTID = ? AND \
-          m.PARTIDMIN = msc.PARTID AND \
+          msc.PARTID >= m.PARTIDMIN AND \
+          msc.PARTID <= m.PARTIDMAX AND \
           msc.PARAMETERID = p.PARAMETERID \
     order by p.GERMANNAME