Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 469:62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Now it will be displayed the Years where measurements happened and than only the dates of the chosen Year will be fetched and displayed.
gnv-artifacts/trunk@532 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 12 Jan 2010 12:42:53 +0000 |
| parents | 363236fc462d |
| children | 64e65daa65e9 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Tue Jan 12 11:34:25 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Jan 12 12:42:53 2010 +0000 @@ -261,6 +261,19 @@ M.FEATUREID = ? and \ TS.PARAMETERID IN ( ? ) + +verticalprofile_year=select distinct \ + to_char(tsv.TIMEVALUE,'YYYY') KEY, \ + to_char(tsv.TIMEVALUE,'YYYY') VALUE \ + from MEDIAN.TIMESERIES ts, \ + MEDIAN.TIMESERIESVALUE tsv, \ + MEDIAN.MEASUREMENT m \ + where ts.TIMESERIESID = tsv.TIMESERIESID and \ + m.MEASUREMENTID = tsv.MEASUREMENTID and \ + m.FEATUREID = ? and \ + ts.PARAMETERID IN ( ? ) \ + order by to_char(tsv.TIMEVALUE,'YYYY') + verticalprofile_date=select distinct \ tsv.TIMEVALUE KEY, \ tsv.TIMEVALUE VALUE \ @@ -270,7 +283,8 @@ where ts.TIMESERIESID = tsv.TIMESERIESID and \ m.MEASUREMENTID = tsv.MEASUREMENTID and \ m.FEATUREID = ? and \ - ts.PARAMETERID IN ( ? ) \ + ts.PARAMETERID IN ( ? ) and \ + to_char(tsv.TIMEVALUE,'YYYY') IN (?) \ order by tsv.TIMEVALUE verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \