Mercurial > dive4elements > gnv-client
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, \