Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 532:d2f97cb2ac32
Splitted date selection of product 'Horizontalschnitt' into two steps.
gnv-artifacts/trunk@628 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 26 Jan 2010 10:46:33 +0000 |
| parents | d5a7608a4eea |
| children | 938ce81a6bd0 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Tue Jan 26 10:16:00 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Jan 26 10:46:33 2010 +0000 @@ -1095,6 +1095,16 @@ MP.MESHID = M.MESHID \ ORDER BY MP.KPOSITION +horizontalcrosssection_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') horizontalcrosssection_mesh_date = select distinct \ msv.TIMEVALUE KEY, \ msv.TIMEVALUE VALUE \ @@ -1103,7 +1113,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 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \