found an interesting discussion right here
http://getsatisfaction.com/opengeo/topics/cql_reference
about default upper usage of the property Expression if using LIKE filters :
What I try to do is using WFS to implement a gazetteer like search for point
of interests. But the user typing the search text doesn't know about the
type of storage (upper or lower case or even Camel Style or whatever).
So is there a solution in geoserver 2.1.x to get results from a like query?
Cheers
Frank
2010/9/30 Frank Gasdorf <[email protected]>
> Hello everybody!
>
> I enabled the WFS service for my local geoserver installation and tried to
> request features with a LIKE Filter to find features with a special name
> attribute. But I couldn't create a case insensitive filter, where attribute
> values and the filter criteria is uppercase.
>
>
> FilterFactory2 filterFactory = CommonFactoryFinder.getFilterFactory2(
> GeoTools.getDefaultHints() );
> String attributeName = "nam";
> String text = "hamburg*"
> Expression upperAttribute = filterFactory.function("strToUpperCase",
> filterFactory.property(attributeName));
> Filter attributeFilter = filterFactory.like(upperAttribute,
> text.toUpperCase(), "*", "?", "\\", false);
>
> the resulting filter looks like that:
> [ strToUpperCase([nam]) is like HAMBURG* ]
>
> But I got no results back from the geoserver 2.0.2 WFS service.
>
> Could you give any hints to solve this problem? Any suggestions? Which
> filters are supported by geoserver
>
> Thanks a lot,
>
> Frank
>
> PS: code snippet is used witth udig 1.2 on geotools 2.6.3
>
>
>
>
>
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
