Hello, I have a lot of PostgreSQL attribute tables which I would like to link to a single geographic table on demand to create thematic maps.
My parametric sql statement is: select a.*,the_geom from %link_table% a, maptable b where a.code = b.code I then created a "dummy" table that contains just a "code" field and used the "dummy" as the default value of the %link_table% so that I can register the layer. My problem is when I make a wms/wfs request with a "viewparams=link_table:attribtab1", I can only get the "code" field and none of the other attribute fields of the table. Since all of my attribute tables have different schemas, is there any of forcing geoserver to read the returned schema from the sql request, and not just the registered field name. Thanks and regards, Mario. ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users