# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1274428441 0
# Node ID 07b829c069819c162e9654f0a38727686ad68db2
# Parent  8a8ee5abc084cb6457ea4bb160a643738949a77d
Integrated View MEDIAN.TIMESERIESFULLVECTORVALUE in queries for vector data on timeSeriesPoints

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

diff -r 8a8ee5abc084 -r 07b829c06981 gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Thu May 20 09:47:19 2010 +0000
+++ b/gnv-artifacts/ChangeLog	Fri May 21 07:54:01 2010 +0000
@@ -1,3 +1,9 @@
+2010-05-21  Tim Englich  <tim.englich@intevation.de>
+
+	* doc/conf/queries.properties: 
+	  Integrated View MEDIAN.TIMESERIESFULLVECTORVALUE in queries for fetching 
+	  the data for Charts and ODV-Export on TimeSeriesPoints using vetcor data.
+
 2010-05-20  Ingo Weinzierl <ingo.weinzierl@intevation.de>
 
 	  Issue27 - Implemented odv export for vector data of timeseriespoints.
diff -r 8a8ee5abc084 -r 07b829c06981 gnv-artifacts/doc/conf/queries.properties
--- a/gnv-artifacts/doc/conf/queries.properties	Thu May 20 09:47:19 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri May 21 07:54:01 2010 +0000
@@ -175,13 +175,13 @@
         tsv.XCOMPONENT, \
         tsv.YCOMPONENT, \
         tsv.ZCOMPONENT, \
-        1 SPEED, \
-        1 DIRECTION, \
+        tsv.SPEED, \
+        tsv.DIRECTION, \
         t.PARAMETERID GROUP1, \
         tsv.MEASUREMENTID GROUP2, \
         tsv.TIMESERIESID GROUP3, \
         t.TIMEINTERVAL GAPID \
-    FROM MEDIAN.TIMESERIESVECTORVALUE tsv, \
+    FROM MEDIAN.TIMESERIESFULLVECTORVALUE tsv, \
          MEDIAN.TIMESERIES t \
     WHERE tsv.TIMESERIESID = t.TIMESERIESID AND \
           t.PARAMETERID = ? AND \
@@ -203,14 +203,14 @@
             TSV.XCOMPONENT, \
             TSV.YCOMPONENT, \
             TSV.ZCOMPONENT, \
-            1 SPEED, \
-            1 DIRECTION, \
+            TSV.SPEED, \
+            TSV.DIRECTION, \
             TS.PARAMETERID PARAMETER, \
             TSV.MEASUREMENTID, \
             TSV.TIMESERIESID, \
             '1' QF \
      FROM MEDIAN.TIMESERIESPOINT, \
-          MEDIAN.TIMESERIESVECTORVALUE TSV, \
+          MEDIAN.TIMESERIESFULLVECTORVALUE TSV, \
           MEDIAN.TIMESERIES TS, \
           MEDIAN.MEASUREMENT M, \
           MEDIAN.SOURCEINFO SI \