[Geoserver-users] Syntax help: Filter by FeatureId from PostGIS tables

Hi

I’m trying to display data from a two PostGIS Tables using the table row id
(Primary key)

I can show two features from Layer1 with

<FeatureId id="1234"></FeaturId>

but if I ad Layer2 it doesn’t work I get an save file dialog box

the actual table id's of Layer1 is 'id' and Layer2 is 'qid'

Localhost:8080/geoserver/cite/wms?service=WMS&version=1.1.0&request=GetMap&layers=cite:Layer1,
cite:Layer2&
styles=&bbox……..width=512,heaight=430&srs=EPSG:4326&application/openlayers

&FILTER= <Filter xmlns="http://www.opengis.net/ogc&quot;&gt;
       <FeatureId fid="Layer1.1234"></FeaturId>
       <FeatureId fid="Layer1.5678"></FeaturId>
       <FeatureId fid="Layer2.345"></FeaturId>
   </Filter>

I’d be grateful if someone could tell me where I’m going wrong.

Note I’ve deliberately left this in expanded form making it easier to read

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Syntax-help-Filter-by-FeatureId-from-PostGIS-tables-tp4471768p4471768.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Sorted

&FILTER= (<Filter xmlns="http://www.opengis.net/ogc&quot;&gt;
    <FeatureId fid=”Layer1.1234”></FeaturId>
    <FeatureId fid=”Layer1.5678”></FeaturId></Filter>)
    (<Filter xmlns="http://www.opengis.net/ogc&quot;&gt;
          <FeatureId fid=”Layer2.345”></FeaturId></Filter>)

Note the brackets

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Syntax-help-Filter-by-FeatureId-from-PostGIS-tables-tp4471768p4475706.html
Sent from the GeoServer - User mailing list archive at Nabble.com.