geoserver 踩坑记录

1. 同时加载多个layer时, cql_filter 出错

Layers and filters are mismatched, you need to provide one filter for each layer

报错信息.png
解决方法: 官方文档
多个layers同时加载时,filter需要分别设置,以 ; (分号)隔开
官方文档.png

2. 使用cql_filter 要urlEncode编码

like

&cql_filter=dkbm like 'xxx%' 这样写不行,下面的写法才对
&cql_filter=dkbm%20like%20%27xxxx%25%27

in

&cql_filter=task_id in ('22', '23')
&cql_filter=task_id%20in%20(%2722%27,%20%2723%27)

多个条件时,用and连接

&cql_filter=town_code in ('22', '23') and user_id = xxx
&cql_filter=town_code+in+(%2722%27%2c%2723%27)+and+user_id+%3d+1102

参考官网