How pass a list to viewparams variables in geoserver sql views?

[المشرف العام]

I have a sql view which take only one parameter, but this parameter is a list, and a need to know how can i pass this parameter in the url

Here is my sql view

SELECT * FROM shop WHERE id IN %list%When I put the default value for %list% as (1, 2 ,3) as example, the layer preview works and show the shopa with the default ids, but when I try this in the url

viewparams=list1,2,3)does not work.

I already tried other things like

viewparams=list:"1,2,3"but nothing works.

Does anyone know how to do this?



أكثر...