comparison gnv-artifacts/doc/conf/queries.properties @ 338:c94936b1f4ba

Added the Unit of the Parameter to the Query for Parameters in TimeSeries. Now the Unit will be displaied in the Combobox and in the Diagramm-Axis-Description. gnv-artifacts/trunk@404 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 08 Dec 2009 13:52:42 +0000
parents 1b9ca0f2d498
children 8f168e12a963
comparison
equal deleted inserted replaced
337:a887074460b6 338:c94936b1f4ba
28 )\ 28 )\
29 ORDER BY MEDIAN.TIMESERIESPOINT.NAME 29 ORDER BY MEDIAN.TIMESERIESPOINT.NAME
30 30
31 timeseries_parameter=SELECT DISTINCT \ 31 timeseries_parameter=SELECT DISTINCT \
32 p.PARAMETERID KEY, \ 32 p.PARAMETERID KEY, \
33 p.GERMANNAME VALUE \ 33 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
34 p.GERMANNAME \
34 FROM MEDIAN.PARAMETER P, \ 35 FROM MEDIAN.PARAMETER P, \
35 MEDIAN.TIMESERIES TS, \ 36 MEDIAN.TIMESERIES TS, \
36 MEDIAN.TIMESERIESVALUE TSV, \ 37 MEDIAN.TIMESERIESVALUE TSV, \
37 MEDIAN.MEASUREMENT M, \ 38 MEDIAN.MEASUREMENT M, \
38 MEDIAN.TIMESERIESPOINT TSP \ 39 MEDIAN.TIMESERIESPOINT TSP \

http://dive4elements.wald.intevation.org