Re: [Geoserver-users] [App-schema plugin] Mapping of 3 tables into 2 features (join table)

2012-06-15 Thread Ben Caradoc-Davies
Rudy, have you considered using a database view to join LinkedTable and Sample1Table? You can then use feature chaining to deliver Sample1 (sourced from the view) nested inside Object1. This approach allows you to retain the correct normalisation of your database with the link table. I also no

[Geoserver-users] [App-schema plugin] Mapping of 3 tables into 2 features (join table)

2012-06-13 Thread RudyWI
Hi, I try to map 3 tables into 2 features. I have these tables : Object1Table (id int, name varchar, desc text, typeid int) LinkedTable (id int, sample1 int, sample2 int, sample3 int) Sample1Table (id int, name varchar, desc text) Relations are - Object1Table.typeid -> LinkedTable.id - Linked