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

[Pedro]

Jonathan Moules-3 wrote
> 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 .osgeo

>  [mailto:

> qgis-user-bounces at .osgeo

> ] On Behalf Of Pedro
> Sent: Monday, June 08, 2015 3:00 PM
> To: 

> qgis-user at .osgeo

> 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?
> 
> http://lists.osgeo.org/mailman/listinfo/qgis-user

Jonathan and Alex, appreciate your insights.
Based on that I will try to built something that "emulate" the 1:n
relationship.



Not quite related but another problem emerged when using the OpenGeo
plugin...
I would like to give a different name (alias) to the columns of my tables
and I did that at QGIS Layer Properties, but when I save the style in a .sld
file but such information is not stored in the file (in a .qml style file
all the information is stored).

So, as anyone know if it's possible to give aliases to columns at geoserver
(or any kind of workaround like converting qml file to sld...) ?

Thanks,
Pedro



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Opengeo-Geoserver-QGIS-1-n-relations-tp5209762p5210950.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.