'How do I pass a list of values in string form to viewparams in geoserver?
I have a SQL view which takes two parameters. One of these parameters is a list of numbers in string form. I can't for the life of me figure out if Geoserver can take this list and parse it.
The basic SQL query i've set up works as below
SELECT * FROM table WHERE id IN '%list%' AND layer = '%layer_name%'
When I put the default value for %list% as "1, 2 ,3" as an example, the call to viewparams might look like this
viewparams=layer_name:'layer_y';ids:1,2,3
Which fails. I've figured out that viewparams uses semicolons to distinguish between parameter types, and commas as a way to distinguish between viewparams for different layers. So I need a way of encapsulating my list of id values so that geoserver can parse them correctly.
Does anyone know how to do this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
