HI Olyster, Really appreciated and yes, this could be the best solution for parameter-zing SQL views. I will do more tests on it. In our case, almost it will be like this [image: image.png]
At lease, I have to redesign our table with standard names like, ID, NAME, POPULATION then I may need to have parameters not only in sql where clause, it may like as "select t1.ID, t1.geometryField, t2.NAME, t2. POPULATION from table t1 inner join %tablename% t2 on t1.id = t2.id where %userinputclumnvalues%". I will give a try to see how works. Best, Tom On Fri, Nov 2, 2018 at 11:47 AM Olyster <[email protected]> wrote: > Hi, > > geoserver layers can be generated from SQL. Moreover you can add parameters > on each one. > > For example, you can setup a layer as "select ID,geometryField, country > from > table where country = %cntry%" and then define a "cntry" parameter to this > view. > > You can then perform GetMap or GetFeature requests and pass the cntry > parameter. > > More info here : > > https://docs.geoserver.org/stable/en/user/data/database/sqlview.html > > Hope this helps. > > > > -- > Sent from: > http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html > > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
