changeset 749:686eecfafbbf

Bugfixes: Fixed the Query for Parameters in Timeseries and VerticalProfiles in Meshes. gnv-artifacts/trunk@789 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 16 Mar 2010 13:10:44 +0000
parents 5b9945798f86
children 3cbf26125829
files gnv-artifacts/ChangeLog gnv-artifacts/doc/conf/queries.properties
diffstat 2 files changed, 10 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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,
--- 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
 

http://dive4elements.wald.intevation.org