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

http://dive4elements.wald.intevation.org