Mercurial > dive4elements > gnv-client
changeset 1042:07b829c06981
Integrated View MEDIAN.TIMESERIESFULLVECTORVALUE in queries for vector data on timeSeriesPoints
gnv-artifacts/trunk@1114 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 21 May 2010 07:54:01 +0000 |
| parents | 8a8ee5abc084 |
| children | d955571cdf2a |
| files | gnv-artifacts/ChangeLog gnv-artifacts/doc/conf/queries.properties |
| diffstat | 2 files changed, 12 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- 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.
--- 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 \