Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 531:b80940231f6e | 532:d2f97cb2ac32 |
|---|---|
| 1093 ML.MESHID = MP.MESHID AND \ | 1093 ML.MESHID = MP.MESHID AND \ |
| 1094 M.OBJECTID = ? AND \ | 1094 M.OBJECTID = ? AND \ |
| 1095 MP.MESHID = M.MESHID \ | 1095 MP.MESHID = M.MESHID \ |
| 1096 ORDER BY MP.KPOSITION | 1096 ORDER BY MP.KPOSITION |
| 1097 | 1097 |
| 1098 horizontalcrosssection_mesh_year = select distinct \ | |
| 1099 to_char(msv.TIMEVALUE,'YYYY') KEY, \ | |
| 1100 to_char(msv.TIMEVALUE,'YYYY') VALUE \ | |
| 1101 from MEDIAN.MESHSCALARVALUE msv, \ | |
| 1102 MEDIAN.MESH m \ | |
| 1103 where m.OBJECTID = ? AND \ | |
| 1104 msv.PARTID >= m.PARTIDMIN AND \ | |
| 1105 msv.PARTID <= m.PARTIDMAX AND \ | |
| 1106 msv.PARAMETERID = ? \ | |
| 1107 order by to_char(msv.TIMEVALUE,'YYYY') | |
| 1098 horizontalcrosssection_mesh_date = select distinct \ | 1108 horizontalcrosssection_mesh_date = select distinct \ |
| 1099 msv.TIMEVALUE KEY, \ | 1109 msv.TIMEVALUE KEY, \ |
| 1100 msv.TIMEVALUE VALUE \ | 1110 msv.TIMEVALUE VALUE \ |
| 1101 from MEDIAN.MESHSCALARVALUE msv, \ | 1111 from MEDIAN.MESHSCALARVALUE msv, \ |
| 1102 MEDIAN.MESH m \ | 1112 MEDIAN.MESH m \ |
| 1103 where m.OBJECTID = ? AND \ | 1113 where m.OBJECTID = ? AND \ |
| 1104 msv.PARTID >= m.PARTIDMIN AND \ | 1114 msv.PARTID >= m.PARTIDMIN AND \ |
| 1105 msv.PARTID <= m.PARTIDMAX AND \ | 1115 msv.PARTID <= m.PARTIDMAX AND \ |
| 1106 msv.PARAMETERID = ? \ | 1116 msv.PARAMETERID = ? AND \ |
| 1117 to_char(msv.TIMEVALUE,'YYYY') in (?) \ | |
| 1107 order by msv.TIMEVALUE | 1118 order by msv.TIMEVALUE |
| 1108 | 1119 |
| 1109 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ | 1120 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ |
| 1110 MSV.DATAVALUE YORDINATE, \ | 1121 MSV.DATAVALUE YORDINATE, \ |
| 1111 MEDIAN.MESHPOINT.JPOSITION, \ | 1122 MEDIAN.MESHPOINT.JPOSITION, \ |