Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 170:7be22e76c270
Added parameter to the DateQueroes of Meshes
gnv-artifacts/trunk@207 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 09 Oct 2009 07:49:47 +0000 |
| parents | 5134266f00e7 |
| children | 1b2fc94766c9 |
comparison
equal
deleted
inserted
replaced
| 126:cfaaa215d8ff | 170:7be22e76c270 |
|---|---|
| 254 msv.TIMEVALUE VALUE \ | 254 msv.TIMEVALUE VALUE \ |
| 255 from MEDIAN.MESHSCALARVALUE msv , \ | 255 from MEDIAN.MESHSCALARVALUE msv , \ |
| 256 MEDIAN.MESH m \ | 256 MEDIAN.MESH m \ |
| 257 where m.OBJECTID = ? AND \ | 257 where m.OBJECTID = ? AND \ |
| 258 msv.PARTID >= m.PARTIDMIN AND \ | 258 msv.PARTID >= m.PARTIDMIN AND \ |
| 259 msv.PARTID <= m.PARTIDMAX \ | 259 msv.PARTID <= m.PARTIDMAX AND \ |
| 260 msv.PARAMETERID in (?) \ | |
| 260 order by msv.TIMEVALUE | 261 order by msv.TIMEVALUE |
| 261 | 262 |
| 262 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ | 263 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ |
| 263 msv.DATAVALUE YORDINATE, \ | 264 msv.DATAVALUE YORDINATE, \ |
| 264 msv.PARAMETERID GROUP1, \ | 265 msv.PARAMETERID GROUP1, \ |