Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 749:686eecfafbbf
Bugfixes: Fixed the Query for Parameters in Timeseries and VerticalProfiles in Meshes.
gnv-artifacts/trunk@789 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 16 Mar 2010 13:10:44 +0000 |
| parents | 2dc0666db49a |
| children | 5d45357dbc6d |
comparison
equal
deleted
inserted
replaced
| 748:5b9945798f86 | 749:686eecfafbbf |
|---|---|
| 162 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ | 162 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
| 163 p.GERMANNAME \ | 163 p.GERMANNAME \ |
| 164 from MEDIAN.PARAMETER p, \ | 164 from MEDIAN.PARAMETER p, \ |
| 165 MEDIAN.MESHSCALARVALUE msc, \ | 165 MEDIAN.MESHSCALARVALUE msc, \ |
| 166 MEDIAN.MESH m \ | 166 MEDIAN.MESH m \ |
| 167 where m.OBJECTID = ? AND \ | 167 where m.OBJECTID = ? AND \ |
| 168 msc.PARTID >= m.PARTIDMIN AND \ | 168 msc.PARTID >= m.PARTIDMIN AND \ |
| 169 msc.PARTID <= m.PARTIDMAX AND \ | 169 msc.PARTID <= m.PARTIDMAX AND \ |
| 170 msc.PARAMETERID = p.PARAMETERID \ | 170 msc.PARAMETERID = p.PARAMETERID \ |
| 171 order by p.GERMANNAME | 171 order by p.GERMANNAME |
| 172 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ | 172 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ |
| 428 p.GERMANNAME \ | 428 p.GERMANNAME \ |
| 429 from MEDIAN.PARAMETER p, \ | 429 from MEDIAN.PARAMETER p, \ |
| 430 MEDIAN.MESHSCALARVALUE msc, \ | 430 MEDIAN.MESHSCALARVALUE msc, \ |
| 431 MEDIAN.MESH m \ | 431 MEDIAN.MESH m \ |
| 432 where m.OBJECTID = ? AND \ | 432 where m.OBJECTID = ? AND \ |
| 433 m.PARTIDMIN = msc.PARTID AND \ | 433 msc.PARTID >= m.PARTIDMIN AND \ |
| 434 msc.PARTID <= m.PARTIDMAX AND \ | |
| 434 msc.PARAMETERID = p.PARAMETERID \ | 435 msc.PARAMETERID = p.PARAMETERID \ |
| 435 order by p.GERMANNAME | 436 order by p.GERMANNAME |
| 436 | 437 |
| 437 verticalprofile_mesh_year= select distinct \ | 438 verticalprofile_mesh_year= select distinct \ |
| 438 to_char(msv.TIMEVALUE,'YYYY') KEY, \ | 439 to_char(msv.TIMEVALUE,'YYYY') KEY, \ |