Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 217:3dcd2b0b456e
Added configurable TimeGap Support to the TimeSeries-Chart-Generation. issu45
gnv-artifacts/trunk@275 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Thu, 29 Oct 2009 15:58:47 +0000 |
| parents | 9db263ee2678 |
| children | 926530bda1a7 |
comparison
equal
deleted
inserted
replaced
| 216:9db263ee2678 | 217:3dcd2b0b456e |
|---|---|
| 52 | 52 |
| 53 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \ | 53 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \ |
| 54 tv.DATAVALUE YORDINATE, \ | 54 tv.DATAVALUE YORDINATE, \ |
| 55 t.PARAMETERID GROUP1, \ | 55 t.PARAMETERID GROUP1, \ |
| 56 tv.MEASUREMENTID GROUP2, \ | 56 tv.MEASUREMENTID GROUP2, \ |
| 57 tv.TIMESERIESID GROUP3 \ | 57 tv.TIMESERIESID GROUP3, \ |
| 58 t.TIMEINTERVAL GAPID \ | |
| 58 FROM MEDIAN.TIMESERIESVALUE tv, \ | 59 FROM MEDIAN.TIMESERIESVALUE tv, \ |
| 59 MEDIAN.TIMESERIES t \ | 60 MEDIAN.TIMESERIES t \ |
| 60 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ | 61 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ |
| 61 t.PARAMETERID IN ( ? ) AND \ | 62 t.PARAMETERID IN ( ? ) AND \ |
| 62 tv.MEASUREMENTID IN ( ? ) AND \ | 63 tv.MEASUREMENTID IN ( ? ) AND \ |
| 123 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ | 124 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ |
| 124 msv.TIMEVALUE XORDINATE, \ | 125 msv.TIMEVALUE XORDINATE, \ |
| 125 msv.DATAVALUE YORDINATE, \ | 126 msv.DATAVALUE YORDINATE, \ |
| 126 msv.PARAMETERID GROUP1, \ | 127 msv.PARAMETERID GROUP1, \ |
| 127 msv.FEATUREID GROUP2, \ | 128 msv.FEATUREID GROUP2, \ |
| 128 mp.FEATUREID GROUP3 \ | 129 mp.FEATUREID GROUP3, \ |
| 130 -1 GAPID \ | |
| 129 from MEDIAN.MESHSCALARVALUE msv , \ | 131 from MEDIAN.MESHSCALARVALUE msv , \ |
| 130 MEDIAN.MESHPOINT mp, \ | 132 MEDIAN.MESHPOINT mp, \ |
| 131 MEDIAN.MESH m \ | 133 MEDIAN.MESH m \ |
| 132 where (m.OBJECTID = ? AND \ | 134 where (m.OBJECTID = ? AND \ |
| 133 msv.PARTID >= m.PARTIDMIN AND \ | 135 msv.PARTID >= m.PARTIDMIN AND \ |