Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 524:d5a7608a4eea
Splitted data selection into two parts. Removed option to disable/enable data points in charts and exports.
gnv-artifacts/trunk@618 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 25 Jan 2010 11:40:05 +0000 |
| parents | c6249cb631df |
| children | d2f97cb2ac32 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Mon Jan 25 11:04:52 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Mon Jan 25 11:40:05 2010 +0000 @@ -984,6 +984,16 @@ ############# Profilschnitt MESH ############ ############################################# ############################################# +verticalcrosssection_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 = ? \ + order by to_char(msv.TIMEVALUE,'YYYY') verticalcrosssection_mesh_date = select distinct \ msv.TIMEVALUE KEY, \ msv.TIMEVALUE VALUE \ @@ -992,7 +1002,8 @@ where m.OBJECTID = ? AND \ msv.PARTID >= m.PARTIDMIN AND \ msv.PARTID <= m.PARTIDMAX AND \ - msv.PARAMETERID = ? \ + msv.PARAMETERID = ? AND \ + to_char(msv.TIMEVALUE,'YYYY') in (?) \ order by msv.TIMEVALUE verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ ((ml.UPPERZLOCATION + ml.LOWERZLOCATION) / 2) Z, \