Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 833:8065295ae255
ISSUE200: Only Layer which contains Items should be displayed
gnv-artifacts/trunk@932 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 16 Apr 2010 08:09:40 +0000 |
| parents | feeaf5aec552 |
| children | 74608c12b4fe |
line wrap: on
line diff
--- 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, \