[Geoserver-users] Filtering on attributes not in feature_id column

GeoServer GeoServer User
1

Hi

I am wanting to make a WFS call, where I can get Geoserver to filter on a column other than FEATURE_ID, is this possible?

In my example, I have a column called Field6 and I just want to bring back those records with an attribute of ‘Private’, not those with an attribute of ‘Public’.

Any help is most appreciated

Thanks

Steve

Steve Campbell | GIS Manager

Corporate Strategy and Communications

Borough of Poole | Civic Centre | Poole BH15 2RU

Tel: 01202 633 362

Email: s.campbell@anonymised.com

Website:www.boroughofpoole.com

Think Green! Please Recycle

2

Hi Steve,

yes. Look here:
http://docs.geoserver.org/latest/en/user/filter/function_reference.html

and here:

http://docs.geoserver.org/latest/en/user/filter/function.html

and the demos in Geoserver itself (left hand menu quite at the bottom)

Cheers

Christian

-----
____________________________

Dr Christian Maul
Project Manager

Information Services Branch
Department Environment and Primary Industries
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Filtering-on-attributes-not-in-feature-id-column-tp5151159p5151258.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

3

On Tue, Jul 15, 2014 at 5:07 PM, Steven Campbell <s.campbell@anonymised.com>
wrote:

Hi

I am wanting to make a WFS call, where I can get Geoserver to filter on a
column other than FEATURE_ID, is this possible?

In my example, I have a column called Field6 and I just want to bring
back those records with an attribute of ‘Private’, not those with an
attribute of ‘Public’.

Any help is most appreciated

The quickest answer would be to add &CQL_FILTER=Field6='Private' to your
GetFeature URL

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------