I am setting up a query against a layer on my GeoServer instance. My query string can become quite complex, and some statements require using multiple '%' wildcards.
For starter's here's an example:
Search for Property Owner: ___________
If the user types in 'Smith', I need to find values that meet the following criteria:
CQL_FILTER=Owner ilike '%Smith%'
However, this is returning all features in my layer.
In fact, when I use just one wildcard, ex. 'Smith%', I still get all features.
What makes this even more difficult is when my query string becomes quite lengthy:
CQL_FILTER=Owner ilike '%Smith%' AND Address ilike '%Main%' AND Value < 100000
Reading the GeoServer docs, I see the wildcard is supported in CQL/ECQL. The syntax is very close to SQL which I have used in the past to do the very same queries.
Anyone have an idea what may be causing this issue? Anyone else have much luck using wildcards in their CQL filters?
Thanks in advance!