Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/src/test/ressources/queries.properties @ 179:f2c76f35da5a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added missing Class Description Values to the Horizontal Profile Charts gnv-artifacts/trunk@223 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Thu, 15 Oct 2009 15:38:15 +0000
parents bff7bbb7c6f0
children 5d050f6de41d
comparison
equal deleted inserted replaced
178:9bcf315f57e4 179:f2c76f35da5a
466 order by mp.KPOSITION 466 order by mp.KPOSITION
467 467
468 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ 468 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
469 msv.DATAVALUE YORDINATE, \ 469 msv.DATAVALUE YORDINATE, \
470 msv.PARAMETERID GROUP1, \ 470 msv.PARAMETERID GROUP1, \
471 msv.TIMEVALUE GROUP2, \ 471 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
472 MEDIAN.MESHPOINT.KPOSITION GROUP3, \ 472 msv.TIMEVALUE GROUP3, \
473 MEDIAN.MESHPOINT.JPOSITION , \ 473 MEDIAN.MESHPOINT.JPOSITION , \
474 MEDIAN.MESHPOINT.IPOSITION \ 474 MEDIAN.MESHPOINT.IPOSITION \
475 from MEDIAN.MESHLAYER ml, \ 475 from MEDIAN.MESHLAYER ml, \
476 MEDIAN.MESHPOINT , \ 476 MEDIAN.MESHPOINT , \
477 MEDIAN.MESH m, \ 477 MEDIAN.MESH m, \
491 MEDIAN.MESH m \ 491 MEDIAN.MESH m \
492 where m.OBJECTID = ? AND \ 492 where m.OBJECTID = ? AND \
493 mp.MESHID = m.MESHID AND \ 493 mp.MESHID = m.MESHID AND \
494 KPOSITION in ( ? ) and \ 494 KPOSITION in ( ? ) and \
495 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 495 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
496 order by MEDIAN.MESHPOINT.KPOSITION, \ 496 order by msv.TIMEVALUE, \
497 msv.TIMEVALUE, \ 497 MEDIAN.MESHPOINT.KPOSITION, \
498 msv.PARAMETERID, \ 498 msv.PARAMETERID, \
499 MEDIAN.MESHPOINT.JPOSITION , \ 499 MEDIAN.MESHPOINT.JPOSITION , \
500 MEDIAN.MESHPOINT.IPOSITION 500 MEDIAN.MESHPOINT.IPOSITION
501 501
http://dive4elements.wald.intevation.org