diff gnv-artifacts/src/test/ressources/queries.properties @ 188:693f7b676ade

Adding two further fis which are based on Mesh to the System. Fis in Median.Mesh will be choosen using the sourceid issue49 gnv-artifacts/trunk@232 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 16 Oct 2009 14:51:43 +0000
parents 5d050f6de41d
children d436c8b27ae3
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties	Fri Oct 16 13:05:40 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/queries.properties	Fri Oct 16 14:51:43 2009 +0000
@@ -93,7 +93,8 @@
 timeseries_mesh = SELECT OBJECTID KEY, \
         m.NAME VALUE \
     FROM MEDIAN.MESH m \
-    order by m.NAME
+    WHERE SOURCEID IN (?) \
+    ORDER BY m.NAME
 timeseries_meshpoint = SELECT FEATUREID, \
         ST_ASTEXT(SHAPE) \
     FROM MEDIAN.MESHPOINT \
@@ -229,6 +230,7 @@
 verticalprofile_mesh = SELECT OBJECTID KEY, \
         m.NAME VALUE \
     FROM MEDIAN.MESH m \
+    WHERE SOURCEID IN (?) \
     order by m.NAME
     
 verticalprofile_mesh_point = SELECT FEATUREID, \

http://dive4elements.wald.intevation.org