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 = '?'

http://dive4elements.wald.intevation.org