[Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations

Jonathan Moules J.Moules at hrwallingford.com
Thu Jun 11 09:22:04 PDT 2015


Hi Pedro,
Generally speaking GeoServer doesn't do 1:n relationships.
At the base level, any GeoServer layer represents just one database table.

There are 3 exceptions:
1) Where GeoServer has been pointed to a View (see Alex's reply)
2) Where you have a layergroup. As their name suggests these contain many layers grouped together to appear as one.
3) If you're using an SQLView - http://docs.geoserver.org/stable/en/user/data/database/sqlview.html

I've not used the OpenGeo plugin so don't know what it's doing when it does the 1:n relationship business.

Cheers,
Jonathan

-----Original Message-----
From: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Pedro
Sent: Monday, June 08, 2015 3:00 PM
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations

Hi,

I'm using Opengeo plugin in QGIS top publish at Geoserver.
Have a problem that I don't know how to handle it.

At QGIS Project Properties established a relationship between two postgis tables (1:n).
So when  when I open an object editor got the information from the two tables. (just 1 table have a geometry column).

By submitting the project to the Geoserver (with OpenGeo plugin) it takes the individual layers, i.e.,  it lose the relationship between the tables.

Are you aware if there is a way to keep this 1:n relationship in Geoserver?


Thanks,
Pedro



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Opengeo-Geoserver-QGIS-1-n-relations-tp5209762.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


This message has been scanned for viruses by MailControl - www.mailcontrol.com



Click https://www.mailcontrol.com/sr/+wtcOCPVva7GX2PQPOmvUikZGg4PuPFT2FIMF37VyACsgpHXbY13Nm94V2BI4XbQuc0HPsxnq8AgL4AI7al!HQ== to report this email as spam.

________________________________

HR Wallingford and its subsidiaries uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them.
If you have received this message in error please advise us immediately and destroy all copies of it.

HR Wallingford Limited
Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
Registered in England No. 02562099

________________________________



More information about the Qgis-user mailing list