GeoServer Configuring the SQL Layer Cql_filter fuzzy query

1. Create a new layer and select the corresponding data source

2 Creating a SQL source layer

3, write good sql, refresh, need to pay attention to set the primary key as an identifier, set the spatial data to Geometory 4326

4, Data filtering access address, support Cql_filter fuzzy query

http://hhzc.hubeiwater.gov.cn/geoserver//ows?service=wfs&version=1.0.0&request=getfeature& Maxfeatures=500000&outputformat=application%2fjson&typename=zbk:wr_int_b_addv_b&cql_filter=int_emp _nm%20like%20%27%25%e6%9d%a8%e6%b9%be%e4%b8%80%e5%8f%b7%25%27

GeoServer Configuring the SQL Layer Cql_filter fuzzy query