IIRC we have switched from the 'CQL2' CQL module to the 'ECQL' one in
GeoServer trunk.  It seems that the older module (which you are still using)
does not allow functions (only property names) as the left-hand-side of a
'LIKE' comparison.

I think updating to GeoServer 2.1 (not yet released, but in RC status) would
allow you to use this filter.  Alternatively, you can rewrite your filter
using nested functions instead:

isLike(strToUpperCase(STATE_NAME) like '%M%')

hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Wed, Feb 23, 2011 at 8:05 AM, SSA <[email protected]> wrote:

>
> Hello All,
>
> I am trying to use CQL filter function available in geoserver but it gives
> me parse error.
>
> Here is the filter function reference:
>
> http://docs.geoserver.org/2.0.x/en/user/filter/function_reference.html
>
> and I took example from this tutorial:
>
> http://docs.geoserver.org/latest/en/user/tutorials/cql/cql_tutorial.html
>
> I use strToUpperCase, for states layer in CQL:
>
> strToUpperCase(STATE_NAME)  like '%M%'
>
> and error message comes:
>
> Could not parse cql filter list.
>
> encountered 'like' at line 1.
>
> when I dont use strToUpperCase it works but why not filter function
> strToUpperCase or strToLowerCase working?
>
> Any help is appreciated.
>
> Thanks in advance.
>
> http://old.nabble.com/file/p30994722/CQL%2Bparse%2Berror.jpg
> --
> View this message in context:
> http://old.nabble.com/CQL-filter-function%2C-parse-error-tp30994722p30994722.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
>
> ------------------------------------------------------------------------------
> Free Software Download: Index, Search & Analyze Logs and other IT data in
> Real-Time with Splunk. Collect, index and harness all the fast moving IT
> data
> generated by your applications, servers and devices whether physical,
> virtual
> or in the cloud. Deliver compliance at lower cost and gain new business
> insights. http://p.sf.net/sfu/splunk-dev2dev
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to