diff gnv-artifacts/doc/conf/queries.properties @ 523:c6249cb631df

Splitted date selection of horizontal profile charts into two parts - selection of a year and selection of a concrete date of this year. gnv-artifacts/trunk@617 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Mon, 25 Jan 2010 11:04:52 +0000
parents 64e65daa65e9
children d5a7608a4eea
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Mon Jan 25 09:18:31 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Mon Jan 25 11:04:52 2010 +0000
@@ -412,6 +412,17 @@
           m.PARTIDMIN = msc.PARTID AND \
           msc.PARAMETERID = p.PARAMETERID \
     order by p.GERMANNAME
+
+verticalprofile_mesh_year= select  distinct \
+        to_char(msv.TIMEVALUE,'YYYY') KEY, \
+        to_char(msv.TIMEVALUE,'YYYY') VALUE \
+    from MEDIAN.MESHSCALARVALUE msv, \
+         MEDIAN.MESH m \
+    where m.OBJECTID = ?  AND \
+          msv.PARTID >= m.PARTIDMIN AND \
+          msv.PARTID <= m.PARTIDMAX AND \
+          msv.PARAMETERID in (?) \
+    order by to_char(msv.TIMEVALUE, 'YYYY')
           
 verticalprofile_mesh_date= select  distinct \
         msv.TIMEVALUE KEY, \
@@ -421,7 +432,8 @@
     where m.OBJECTID = ?  AND \
           msv.PARTID >= m.PARTIDMIN AND \
           msv.PARTID <= m.PARTIDMAX AND \
-          msv.PARAMETERID in (?) \
+          msv.PARAMETERID in (?) AND \
+          to_char(msv.TIMEVALUE,'YYYY') in (?) \
     order by msv.TIMEVALUE
 
 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \

http://dive4elements.wald.intevation.org