Oops, the CQL I posted was not what I meant. You can try this: isLike(strToUpperCase(STATE_ABBR), '%M%') == true
You could also look into using XML-encoded filters (like you use in SLD) instead of CQL. -- David Winslow OpenGeo - http://opengeo.org/ On Wed, Feb 23, 2011 at 10:39 AM, SSA <[email protected]> wrote: > > Thank you David for your reply and time but this didn't work either. I have > stable version in production so I am afraid if I can do anything to improve > search. I'll install 2.1 RC to see if this works there. > > Its strange that documentation for 2.0 still mentions to use cql filter > function while they don't work. > > > > David Winslow-5 wrote: > > > > 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: > > > > > > > > -- > View this message in context: > http://old.nabble.com/CQL-filter-function%2C-parse-error-tp30994722p30995962.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
