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, \

http://dive4elements.wald.intevation.org