# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1254826727 0
# Node ID 5134266f00e7630aad9765f2df76d32abebc2bff
# Parent  4841808819d9db1f5a40034446edcc4ae3df70fa
Resolved gnv/issue21 No NPE will be thrown.
Add Dummydata for Calculating the distance between two MeasurmentPoints.

gnv-artifacts/trunk@190 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 4841808819d9 -r 5134266f00e7 gnv-artifacts/Changelog
--- a/gnv-artifacts/Changelog	Mon Oct 05 10:15:15 2009 +0000
+++ b/gnv-artifacts/Changelog	Tue Oct 06 10:58:47 2009 +0000
@@ -1,3 +1,14 @@
+2009-10-06  Tim Englich  <tim.englich@intevation.de>
+
+    * src/test/ressources/queries.properties Edited:
+      Bugfix in Query for getting Data for the Output.
+      Now the Values will be sorted Correcly. Timevalue
+      has been removed from the Query because it is not a
+      Parameter which could be choosen from the User.
+      Also dummies for XCOORD-Value and YCOORD-Value integrated so 
+      that is now Possible to visualize the Profile
+      gnv/issue21
+      
 2009-10-05  Tim Englich  <tim.englich@intevation.de>
 
     * src/main/java/de/intevation/gnv/artifacts/ressource/artifactMessages*.properties Edited:
diff -r 4841808819d9 -r 5134266f00e7 gnv-artifacts/src/test/ressources/queries.properties
--- a/gnv-artifacts/src/test/ressources/queries.properties	Mon Oct 05 10:15:15 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/queries.properties	Tue Oct 06 10:58:47 2009 +0000
@@ -421,12 +421,12 @@
     WHERE M.FEATUREID = IP.FEATUREID AND \
           IP.SURVEYID = ? \
     ORDER BY M.ZLOCATION
-horizontalprofile_instantaneouspoint_chart_data = SELECT M.XLOCATION XORDINATE_XCOORD , \
-        M.YLOCATION XORDINATE_YCOORD , \
+horizontalprofile_instantaneouspoint_chart_data = SELECT MSV.OBJECTID XORDINATE_XCOORD , \
+        MSV.OBJECTID XORDINATE_YCOORD , \
         MSV.DATAVALUE  YORDINATE , \
         MSV.PARAMETERID GROUP1 , \
-        IP.TIMEVALUE GROUP2 , \
-        ZLOCATION GROUP3 \
+        ZLOCATION GROUP2 , \
+        1 GROUP3 \
     FROM MEDIAN.INSTANTANEOUSPOINT IP, \
          MEDIAN.MEASUREMENT M, \
          MEDIAN.MEASUREDSCALARVALUE MSV \
@@ -435,10 +435,9 @@
           IP.SURVEYID = ? AND \
           M.ZLOCATION IN (?) AND \
           MSV.PARAMETERID in (?) \
-    ORDER BY M.ZLOCATION, \
-          MSV.PARAMETERID, \
-          IP.TIMEVALUE
-          
+    ORDER BY MSV.PARAMETERID, \
+             M.ZLOCATION
+             
 #############################################
 #############################################
 ########### Horizontalprofil MESH ###########
@@ -492,5 +491,4 @@
             msv.PARAMETERID, \
             mp.JPOSITION , \
             mp.IPOSITION
-            
              
\ No newline at end of file