diff 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
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Tue Dec 15 14:35:41 2009 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Tue Dec 15 14:55:42 2009 +0000
@@ -148,7 +148,8 @@
 
 timeseries_mesh_parameter=SELECT distinct \
         p.PARAMETERID KEY, \
-        p.GERMANNAME VALUE \
+        p.GERMANNAME || '  ['|| p.UNIT ||']' VALUE, \
+        p.GERMANNAME \
     from MEDIAN.PARAMETER p, \
          MEDIAN.MESHSCALARVALUE msc, \
          MEDIAN.MESH m \
@@ -238,7 +239,8 @@
 
 verticalprofile_parameter=SELECT DISTINCT \
            p.PARAMETERID KEY, \
-           p.GERMANNAME VALUE \
+           p.GERMANNAME || '  ['|| p.UNIT ||']' VALUE, \
+           p.GERMANNAME \
     from MEDIAN.PARAMETER p, \
            MEDIAN.TIMESERIES ts, \
            MEDIAN.TIMESERIESVALUE tsv, \
@@ -387,7 +389,8 @@
     
 verticalprofile_mesh_parameter=SELECT distinct \
         p.PARAMETERID KEY, \
-        p.GERMANNAME VALUE \
+        p.GERMANNAME || '  ['|| p.UNIT ||']' VALUE, \
+        p.GERMANNAME \
     from MEDIAN.PARAMETER p, \
          MEDIAN.MESHSCALARVALUE msc, \
          MEDIAN.MESH m  \
@@ -530,7 +533,8 @@
 
 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
         P.PARAMETERID KEY, \
-        P.GERMANNAME VALUE \
+        p.GERMANNAME || '  ['|| p.UNIT ||']' VALUE, \
+        p.GERMANNAME \
     FROM MEDIAN.PARAMETER P, \
          MEDIAN.INSTANTANEOUSPOINT IP, \
          MEDIAN.MEASUREMENT M, \
@@ -723,7 +727,8 @@
              DESCRIPTION
 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
         P.PARAMETERID KEY, \
-        P.GERMANNAME VALUE \
+        p.GERMANNAME || '  ['|| p.UNIT ||']' VALUE, \
+        p.GERMANNAME \
     FROM MEDIAN.PARAMETER P, \
          MEDIAN.MEASUREMENT M, \
          MEDIAN.INSTANTANEOUSPOINT IP, \

http://dive4elements.wald.intevation.org