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, \ |