Hi,
If I have a relational database underneath geoserver (a PostGIS
database), is it possible to use more than one table in an SLD rule filter?
At first glance, this seems not to be the case, as when publishing a
layer, one can only specify a single table or view. But still would like
to hear expert confirmation 
Best regards,
Akos
A couple of options:
On Thu, Nov 8, 2012 at 1:19 PM, Ákos Maróy <akos@anonymised.com> wrote:
Hi,
If I have a relational database underneath geoserver (a PostGIS
database), is it possible to use more than one table in an SLD rule filter?At first glance, this seems not to be the case, as when publishing a
layer, one can only specify a single table or view. But still would like
to hear expert confirmationBest regards,
Akos
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Martin Davis
OpenGeo - http://opengeo.org
Expert service straight from the developers.
On 08/11/12 22:35, Martin Davis wrote:
A couple of options:
- join the tables in a SQL
View: http://docs.geoserver.org/stable/en/user/data/database/sqlview.html
yeah, but this wouldn't work as I have 1..n relationships as well, which
can't be well modeled via a join/view
- use cross-layer
filtering: http://docs.geoserver.org/stable/en/user/extensions/querylayer/index.html
hm, let me look at this, thank you