Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 356:3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
all Parameterqueries where it was still missing. Now the Unit will
be displaied in the Combobox and in the Diagramm-Axis-Description
gnv-artifacts/trunk@429 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Tim Englich <tim.englich@intevation.de> |
---|---|
date | Tue, 15 Dec 2009 14:55:42 +0000 |
parents | 24c21a720aa5 |
children | 061355435075 |
comparison
equal
deleted
inserted
replaced
355:fce70ff3486b | 356:3eee1369c79b |
---|---|
146 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ | 146 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ |
147 ORDER BY ML.UPPERZLOCATION DESC | 147 ORDER BY ML.UPPERZLOCATION DESC |
148 | 148 |
149 timeseries_mesh_parameter=SELECT distinct \ | 149 timeseries_mesh_parameter=SELECT distinct \ |
150 p.PARAMETERID KEY, \ | 150 p.PARAMETERID KEY, \ |
151 p.GERMANNAME VALUE \ | 151 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
152 p.GERMANNAME \ | |
152 from MEDIAN.PARAMETER p, \ | 153 from MEDIAN.PARAMETER p, \ |
153 MEDIAN.MESHSCALARVALUE msc, \ | 154 MEDIAN.MESHSCALARVALUE msc, \ |
154 MEDIAN.MESH m \ | 155 MEDIAN.MESH m \ |
155 where m.OBJECTID = ? AND \ | 156 where m.OBJECTID = ? AND \ |
156 msc.PARTID = m.PARTIDMIN AND \ | 157 msc.PARTID = m.PARTIDMIN AND \ |
236 mmt.SOURCEID = ? \ | 237 mmt.SOURCEID = ? \ |
237 order by tsp.name | 238 order by tsp.name |
238 | 239 |
239 verticalprofile_parameter=SELECT DISTINCT \ | 240 verticalprofile_parameter=SELECT DISTINCT \ |
240 p.PARAMETERID KEY, \ | 241 p.PARAMETERID KEY, \ |
241 p.GERMANNAME VALUE \ | 242 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
243 p.GERMANNAME \ | |
242 from MEDIAN.PARAMETER p, \ | 244 from MEDIAN.PARAMETER p, \ |
243 MEDIAN.TIMESERIES ts, \ | 245 MEDIAN.TIMESERIES ts, \ |
244 MEDIAN.TIMESERIESVALUE tsv, \ | 246 MEDIAN.TIMESERIESVALUE tsv, \ |
245 MEDIAN.MEASUREMENT m \ | 247 MEDIAN.MEASUREMENT m \ |
246 where ts.PARAMETERID = p.PARAMETERID and \ | 248 where ts.PARAMETERID = p.PARAMETERID and \ |
385 MP.KPOSITION < ? \ | 387 MP.KPOSITION < ? \ |
386 ORDER BY ML.UPPERZLOCATION DESC | 388 ORDER BY ML.UPPERZLOCATION DESC |
387 | 389 |
388 verticalprofile_mesh_parameter=SELECT distinct \ | 390 verticalprofile_mesh_parameter=SELECT distinct \ |
389 p.PARAMETERID KEY, \ | 391 p.PARAMETERID KEY, \ |
390 p.GERMANNAME VALUE \ | 392 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
393 p.GERMANNAME \ | |
391 from MEDIAN.PARAMETER p, \ | 394 from MEDIAN.PARAMETER p, \ |
392 MEDIAN.MESHSCALARVALUE msc, \ | 395 MEDIAN.MESHSCALARVALUE msc, \ |
393 MEDIAN.MESH m \ | 396 MEDIAN.MESH m \ |
394 where m.OBJECTID = ? AND \ | 397 where m.OBJECTID = ? AND \ |
395 m.PARTIDMIN = msc.PARTID AND \ | 398 m.PARTIDMIN = msc.PARTID AND \ |
528 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | 531 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ |
529 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE | 532 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE |
530 | 533 |
531 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ | 534 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ |
532 P.PARAMETERID KEY, \ | 535 P.PARAMETERID KEY, \ |
533 P.GERMANNAME VALUE \ | 536 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
537 p.GERMANNAME \ | |
534 FROM MEDIAN.PARAMETER P, \ | 538 FROM MEDIAN.PARAMETER P, \ |
535 MEDIAN.INSTANTANEOUSPOINT IP, \ | 539 MEDIAN.INSTANTANEOUSPOINT IP, \ |
536 MEDIAN.MEASUREMENT M, \ | 540 MEDIAN.MEASUREMENT M, \ |
537 MEDIAN.MEASUREDSCALARVALUE MSV \ | 541 MEDIAN.MEASUREDSCALARVALUE MSV \ |
538 WHERE IP.FEATUREID = M.FEATUREID AND \ | 542 WHERE IP.FEATUREID = M.FEATUREID AND \ |
721 ORDER BY STARTDATE, \ | 725 ORDER BY STARTDATE, \ |
722 ENDDATE, \ | 726 ENDDATE, \ |
723 DESCRIPTION | 727 DESCRIPTION |
724 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ | 728 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ |
725 P.PARAMETERID KEY, \ | 729 P.PARAMETERID KEY, \ |
726 P.GERMANNAME VALUE \ | 730 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
731 p.GERMANNAME \ | |
727 FROM MEDIAN.PARAMETER P, \ | 732 FROM MEDIAN.PARAMETER P, \ |
728 MEDIAN.MEASUREMENT M, \ | 733 MEDIAN.MEASUREMENT M, \ |
729 MEDIAN.INSTANTANEOUSPOINT IP, \ | 734 MEDIAN.INSTANTANEOUSPOINT IP, \ |
730 MEDIAN.MEASUREDSCALARVALUE MSV \ | 735 MEDIAN.MEASUREDSCALARVALUE MSV \ |
731 WHERE P.PARAMETERID = MSV.PARAMETERID AND \ | 736 WHERE P.PARAMETERID = MSV.PARAMETERID AND \ |