Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 175:14263534255b
Added Parameter-Usage in Time-Interval-Query ISSUE-33
gnv-artifacts/trunk@214 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 13 Oct 2009 10:30:01 +0000 |
| parents | dbf68950b4d9 |
| children | bff7bbb7c6f0 |
comparison
equal
deleted
inserted
replaced
| 174:dbf68950b4d9 | 175:14263534255b |
|---|---|
| 135 max(TIMEVALUE) MAX \ | 135 max(TIMEVALUE) MAX \ |
| 136 from MEDIAN.MESHSCALARVALUE msc , \ | 136 from MEDIAN.MESHSCALARVALUE msc , \ |
| 137 MEDIAN.MESH m \ | 137 MEDIAN.MESH m \ |
| 138 where m.OBJECTID = ? AND \ | 138 where m.OBJECTID = ? AND \ |
| 139 msc.PARTID >= m.PARTIDMIN AND \ | 139 msc.PARTID >= m.PARTIDMIN AND \ |
| 140 msc.PARTID <= m.PARTIDMAX | 140 msc.PARTID <= m.PARTIDMAX AND \ |
| 141 msc.PARAMETERID IN (?) | |
| 141 | 142 |
| 142 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ | 143 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ |
| 143 msv.TIMEVALUE XORDINATE, \ | 144 msv.TIMEVALUE XORDINATE, \ |
| 144 msv.DATAVALUE YORDINATE, \ | 145 msv.DATAVALUE YORDINATE, \ |
| 145 msv.PARAMETERID GROUP1, \ | 146 msv.PARAMETERID GROUP1, \ |