[Geoserver-users] Config layer group with two sql layers

GeoServer GeoServer User
1

Hi, is possible config two sql layers in layergroup using geoserver
For example, i have a layer group named mylayergroup and send to parameters

parameter1 to sqllayer 1 and parameter2 to sqllayer2

how to send wms request with viewparams to two layers?

http://my_host:8080/geoserver/myworkspace/wms?
service=WMS&
version=1.1.0&
request=GetMap&
layers=cspagro_lg&
styles=&bbox=-50.0150126143555,-24.7983216672558,-49.8200717941113,-24.5081695226998&
width=343&
height=512&
srs=EPSG:4326&
format=application/openlayers&
viewparams=parameter1:3561149961959647279;parameter2=23232323

–
Att…
Jairo de Almeida
email: jairodealmeida@anonymised.com

nome skype: jairodealmeida

2

Ciao Jairo,
thinking...

going by memory, it should work as you indicate, although honestly I have
always used it with a single view in the request as indicated in the docs:
http://docs.geoserver.org/stable/en/user/data/database/sqlview.html#using-a-parametric-sql-view

Is this not working for you?

On Thu, Feb 20, 2014 at 10:49 PM, Jairo de Almeida <jairodealmeida@anonymised.com

wrote:

viewparams

Regards,
Simone Giannecchini

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

3

On Thu, Feb 20, 2014 at 10:49 PM, Jairo de Almeida <jairodealmeida@anonymised.com

wrote:

Hi, is possible config two sql layers in layergroup using geoserver
For example, i have a layer group named mylayergroup and send to
parameters

parameter1 to sqllayer 1 and parameter2 to sqllayer2

how to send wms request with viewparams to two layers?

http://my_host:8080/geoserver/myworkspace/wms?
service=WMS&
version=1.1.0&
request=GetMap&
layers=cspagro_lg&

styles=&bbox=-50.0150126143555,-24.7983216672558,-49.8200717941113,-24.5081695226998&
width=343&
height=512&
srs=EPSG:4326&
format=application/openlayers&
viewparams=parameter1:3561149961959647279;parameter2=23232323

It should work, as the layer group is simply expanded in the layer list it
contains
the very moment we parse the request.
However, the correct syntax is:
viewparams=parameter1:3561149961959647279;parameter2:23232323

(mind the second param, it had a =, it should be a : instead)

Cheers
Andrea

--
== Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information ==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

4

Error in the parameter2, sorry my fail =)
Now works fine

parameter2=23232323

Correct is
parameter2:23232323
Thanks guys

···

2014-02-20 18:49 GMT-03:00 Jairo de Almeida <jairodealmeida@anonymised.com>:

Hi, is possible config two sql layers in layergroup using geoserver
For example, i have a layer group named mylayergroup and send to parameters

parameter1 to sqllayer 1 and parameter2 to sqllayer2

how to send wms request with viewparams to two layers?

http://my_host:8080/geoserver/myworkspace/wms?
service=WMS&
version=1.1.0&
request=GetMap&
layers=cspagro_lg&
styles=&bbox=-50.0150126143555,-24.7983216672558,-49.8200717941113,-24.5081695226998&
width=343&
height=512&
srs=EPSG:4326&
format=application/openlayers&
viewparams=parameter1:3561149961959647279;parameter2=23232323

–
Att…
Jairo de Almeida
email: jairodealmeida@anonymised.com

nome skype: jairodealmeida

–
Att…
Jairo de Almeida
email: jairodealmeida@anonymised.com

nome skype: jairodealmeida