Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 523:c6249cb631df | 524:d5a7608a4eea |
|---|---|
| 982 ############################################# | 982 ############################################# |
| 983 ############################################# | 983 ############################################# |
| 984 ############# Profilschnitt MESH ############ | 984 ############# Profilschnitt MESH ############ |
| 985 ############################################# | 985 ############################################# |
| 986 ############################################# | 986 ############################################# |
| 987 verticalcrosssection_mesh_year = select distinct \ | |
| 988 to_char(msv.TIMEVALUE,'YYYY') KEY, \ | |
| 989 to_char(msv.TIMEVALUE,'YYYY') VALUE \ | |
| 990 from MEDIAN.MESHSCALARVALUE msv, \ | |
| 991 MEDIAN.MESH m \ | |
| 992 where m.OBJECTID = ? AND \ | |
| 993 msv.PARTID >= m.PARTIDMIN AND \ | |
| 994 msv.PARTID <= m.PARTIDMAX AND \ | |
| 995 msv.PARAMETERID = ? \ | |
| 996 order by to_char(msv.TIMEVALUE,'YYYY') | |
| 987 verticalcrosssection_mesh_date = select distinct \ | 997 verticalcrosssection_mesh_date = select distinct \ |
| 988 msv.TIMEVALUE KEY, \ | 998 msv.TIMEVALUE KEY, \ |
| 989 msv.TIMEVALUE VALUE \ | 999 msv.TIMEVALUE VALUE \ |
| 990 from MEDIAN.MESHSCALARVALUE msv, \ | 1000 from MEDIAN.MESHSCALARVALUE msv, \ |
| 991 MEDIAN.MESH m \ | 1001 MEDIAN.MESH m \ |
| 992 where m.OBJECTID = ? AND \ | 1002 where m.OBJECTID = ? AND \ |
| 993 msv.PARTID >= m.PARTIDMIN AND \ | 1003 msv.PARTID >= m.PARTIDMIN AND \ |
| 994 msv.PARTID <= m.PARTIDMAX AND \ | 1004 msv.PARTID <= m.PARTIDMAX AND \ |
| 995 msv.PARAMETERID = ? \ | 1005 msv.PARAMETERID = ? AND \ |
| 1006 to_char(msv.TIMEVALUE,'YYYY') in (?) \ | |
| 996 order by msv.TIMEVALUE | 1007 order by msv.TIMEVALUE |
| 997 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ | 1008 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ |
| 998 ((ml.UPPERZLOCATION + ml.LOWERZLOCATION) / 2) Z, \ | 1009 ((ml.UPPERZLOCATION + ml.LOWERZLOCATION) / 2) Z, \ |
| 999 msv.DATAVALUE YORDINATE, \ | 1010 msv.DATAVALUE YORDINATE, \ |
| 1000 msv.PARAMETERID GROUP1, \ | 1011 msv.PARAMETERID GROUP1, \ |