Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 756:1614b27dcbfa
Added Support of Layers which are Joined from two Tables.
gnv-artifacts/trunk@804 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Tim Englich <tim.englich@intevation.de> |
---|---|
date | Fri, 19 Mar 2010 12:12:10 +0000 |
parents | 5d45357dbc6d |
children | b3f922908a31 |
comparison
equal
deleted
inserted
replaced
755:8dc8d04084d4 | 756:1614b27dcbfa |
---|---|
1322 geometry_for_subareafilter=SELECT st_astext(SHAPE) \ | 1322 geometry_for_subareafilter=SELECT st_astext(SHAPE) \ |
1323 FROM MEDIAN.FEATUREAREA \ | 1323 FROM MEDIAN.FEATUREAREA \ |
1324 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | 1324 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
1325 FEATURECODE = ? | 1325 FEATURECODE = ? |
1326 | 1326 |
1327 layer_colums= SELECT COLUMN_NAME \ | 1327 layer_colums= SELECT OWNER || '.' || TABLE_NAME || '.' || COLUMN_NAME \ |
1328 FROM SDE.COLUMN_REGISTRY \ | 1328 FROM SDE.COLUMN_REGISTRY \ |
1329 WHERE COLUMN_NAME NOT LIKE 'SHAPE' AND \ | 1329 WHERE COLUMN_NAME NOT LIKE 'SHAPE' AND \ |
1330 OWNER = '?' AND \ | 1330 OWNER = '?' AND \ |
1331 TABLE_NAME = '?' | 1331 TABLE_NAME = '?' |