Mercurial > dive4elements > gnv-client
changeset 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 | 820fab05d035 |
| children | 520a3b4da484 |
| files | gnv-artifacts/ChangeLog gnv-artifacts/doc/conf/queries.properties |
| diffstat | 2 files changed, 12 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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
--- 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, \