# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1271405380 0
# Node ID 8065295ae255baad39fd9b1275c624fbcbadadb4
# Parent  820fab05d03524e3579f9973587b33ca37b8b9fd
ISSUE200: Only Layer which contains Items should be displayed

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

diff -r 820fab05d035 -r 8065295ae255 gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Fri Apr 16 07:28:47 2010 +0000
+++ b/gnv-artifacts/ChangeLog	Fri Apr 16 08:09:40 2010 +0000
@@ -1,3 +1,13 @@
+2010-04-16  Tim Englich  <tim.englich@intevation.de>
+
+	  ISSUE200
+
+	* doc/conf/queries.properties: 
+	  Modified Query for selecting available Layer for product Layer.
+	  The table has an Column named Items which contains the Number of Items
+	  that are in the Layer. Only Layer which are not empty should be
+	  displayed.
+
 2010-04-15  Ingo Weinzierl <ingo.weinzierl@intevation.de>
 
 	  Issue175
diff -r 820fab05d035 -r 8065295ae255 gnv-artifacts/doc/conf/queries.properties
--- a/gnv-artifacts/doc/conf/queries.properties	Fri Apr 16 07:28:47 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri Apr 16 08:09:40 2010 +0000
@@ -1367,7 +1367,8 @@
 layer = SELECT ROW_ID KEY, \
         TITLE || '-' || LAYER_NAME || '-' || BAND VALUE \
     FROM MEDIAN.LAYER_HAS_SUBTYPES \
-    WHERE ID_FEATURECLASS LIKE ? \
+    WHERE ID_FEATURECLASS LIKE ? AND \
+          ITEMS > 0 \
     ORDER BY LAYER_NAME
     
 layer_request_data = SELECT ID_FEATURECLASS, \