Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 523:c6249cb631df
Splitted date selection of horizontal profile charts into two parts - selection of a year and selection of a concrete date of this year.
gnv-artifacts/trunk@617 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 25 Jan 2010 11:04:52 +0000 |
| parents | 64e65daa65e9 |
| children | d5a7608a4eea |
comparison
equal
deleted
inserted
replaced
| 522:c896282c2601 | 523:c6249cb631df |
|---|---|
| 410 MEDIAN.MESH m \ | 410 MEDIAN.MESH m \ |
| 411 where m.OBJECTID = ? AND \ | 411 where m.OBJECTID = ? AND \ |
| 412 m.PARTIDMIN = msc.PARTID AND \ | 412 m.PARTIDMIN = msc.PARTID AND \ |
| 413 msc.PARAMETERID = p.PARAMETERID \ | 413 msc.PARAMETERID = p.PARAMETERID \ |
| 414 order by p.GERMANNAME | 414 order by p.GERMANNAME |
| 415 | |
| 416 verticalprofile_mesh_year= select distinct \ | |
| 417 to_char(msv.TIMEVALUE,'YYYY') KEY, \ | |
| 418 to_char(msv.TIMEVALUE,'YYYY') VALUE \ | |
| 419 from MEDIAN.MESHSCALARVALUE msv, \ | |
| 420 MEDIAN.MESH m \ | |
| 421 where m.OBJECTID = ? AND \ | |
| 422 msv.PARTID >= m.PARTIDMIN AND \ | |
| 423 msv.PARTID <= m.PARTIDMAX AND \ | |
| 424 msv.PARAMETERID in (?) \ | |
| 425 order by to_char(msv.TIMEVALUE, 'YYYY') | |
| 415 | 426 |
| 416 verticalprofile_mesh_date= select distinct \ | 427 verticalprofile_mesh_date= select distinct \ |
| 417 msv.TIMEVALUE KEY, \ | 428 msv.TIMEVALUE KEY, \ |
| 418 msv.TIMEVALUE VALUE \ | 429 msv.TIMEVALUE VALUE \ |
| 419 from MEDIAN.MESHSCALARVALUE msv, \ | 430 from MEDIAN.MESHSCALARVALUE msv, \ |
| 420 MEDIAN.MESH m \ | 431 MEDIAN.MESH m \ |
| 421 where m.OBJECTID = ? AND \ | 432 where m.OBJECTID = ? AND \ |
| 422 msv.PARTID >= m.PARTIDMIN AND \ | 433 msv.PARTID >= m.PARTIDMIN AND \ |
| 423 msv.PARTID <= m.PARTIDMAX AND \ | 434 msv.PARTID <= m.PARTIDMAX AND \ |
| 424 msv.PARAMETERID in (?) \ | 435 msv.PARAMETERID in (?) AND \ |
| 436 to_char(msv.TIMEVALUE,'YYYY') in (?) \ | |
| 425 order by msv.TIMEVALUE | 437 order by msv.TIMEVALUE |
| 426 | 438 |
| 427 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ | 439 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ |
| 428 msv.DATAVALUE YORDINATE, \ | 440 msv.DATAVALUE YORDINATE, \ |
| 429 mp.KPOSITION KPOSITION, \ | 441 mp.KPOSITION KPOSITION, \ |