[Geoserver-users] filter_option parameter in PostGIS-View?

GeoServer GeoServer User
1

hi,

is it somehow possible to pass a filter_option variable from a getMapRequest to a view in Postgis? I guess it's not?

thanks
ivo

2

Hi Ivo,

It is not exactly clear what you mean. Yes, GetMap requests support filters, both ogc style and cql style. For instance:

...request=getMap&layers=states&cql_filter=STATE_ABBR+EQ+'TX'

Will be turned into a WHERE class like "WHERE STATE_ABBR = 'TX'"

As for supporting views, should be no problem. As long as your view has an entry in geometry_columns it is no problem.

-Justin

Ivo Brodien wrote:

hi,

is it somehow possible to pass a filter_option variable from a getMapRequest to a view in Postgis? I guess it's not?

thanks
ivo

------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

3

Sorry, I did not reply to the list in first place.

BTW: when I use 'reply to all' will the person that i answer to not get the email twice? Once directly and secondly via the list?

thx
ivo

Hi Justin,

It is not exactly clear what you mean. Yes, GetMap requests support filters, both ogc style and cql style. For instance:

sorry, I did noch explain well what I mean.

I will try again:

If this would be my SELECT Statement:

SELECT pid AS oid, AsSVG(way,relative, precision), name FROM planet_osm_roads;

or

SELECT simplify(way,distance), name FROM planet_osm_roads;

I want "relative","precision" & "distance" to be replaced by filter_option parameters...

I have to admin, that I did not even find out if a view has something as parameters...still searching...

thanks
ivo