I've fixed with
var filter = "strToLowerCase(LABEL) like '%via passo%'";
now it works, thanks you all
- Antonio
On Tue, Apr 26, 2011 at 10:48 PM, David Winslow <dwins...@opengeo.org>wrote:
> The ECQL.toFilter() bit of that is Java code. GeoServer will basically
> provide that for you.
>
> Try making your filter text just "isLike(strToLowerCase(LABEL), 'via
> passo%')" and see if that works better.
>
> --
> David Winslow
> OpenGeo - http://opengeo.org/
>
> On Tue, Apr 26, 2011 at 4:34 PM, Antonio Parrotta <
> antonioparro...@gmail.com> wrote:
>
>> Hi Andrea,
>>
>> I'm still trying to figure out how to play with CQL filters to query by
>> attributes. I've found that Geoserver 2.1RC4 sould support ECQL filters but
>> the filter I'm building is not well interpreted.
>>
>> what I'm doing is:
>>
>> var filter = "ECQL.toFilter(isLike(strToLowerCase(LABEL), 'via passo%') ==
>> true)";
>>
>> baseLyr.mergeNewParams({ 'cql_filter': filter });
>>
>> it throuws an exception, like could not parse CQL filter list.
>>
>> any idea?
>>
>> thanks a lot
>>
>> - Antonio
>>
>>
>> On Thu, Apr 14, 2011 at 10:54 PM, Andrea Aime <
>> andrea.a...@geo-solutions.it> wrote:
>>
>>> On Wed, Apr 13, 2011 at 11:16 PM, Phil Scadden <p.scad...@gns.cri.nz>wrote:
>>>
>>>>
>>>> > Using OL + WFS as Ricardo suggested is another option. It will give
>>>> > you more control,probably nice popup functionality and visual feedback
>>>> as you hover on the selection, but it won't scale up to large selections
>>>> (e.g., more than a few tens of features) whilst the approach I'm suggesting
>>>> above will be much more static but will scale up to whatever selection size
>>>> with no particular problems.
>>>> >
>>>> Andrea - the SLDSelect control in Openlayers more less implements what
>>>> you suggest.
>>>
>>>
>>> I see, good to know
>>>
>>>
>>>> This issue with it is that SLD filters are not honouring
>>>> the SRS of spatial geometry on geoserver (though they are honoured on
>>>> mapserver). If the spatial filter in the sld is in the same SRS as the
>>>> layer in geoserver, this mechanism scale fine.
>>>>
>>>>
>>> Yeah, in GeoServer we have to reproject the filters to the native SRS
>>> before
>>> they hit the data sources, since none of them is capable of handling
>>> filters in a srs other than the native one.
>>>
>>> In WFS we have good support for both parsing the srs and reprojecting the
>>> filter back to the native store srs, but in SLD handling we don't have
>>> anything
>>> like that.
>>> We'd need to check if the (old) SLD 1.0 parser is able to attach the srs
>>> information
>>> to geometries, if so adding filter reprojection would be possible using
>>> the
>>> same machinery used for WFS
>>>
>>> I'd suggest to add a request for improvement. If anybody feels like
>>> implementing
>>> this I can give directions on what code to touch.
>>>
>>> Cheers
>>> Andrea
>>>
>>> --
>>> -------------------------------------------------------
>>> Ing. Andrea Aime
>>> GeoSolutions S.A.S.
>>> Tech lead
>>>
>>> Via Poggio alle Viti 1187
>>> 55054 Massarosa (LU)
>>> Italy
>>>
>>> phone: +39 0584 962313
>>> fax: +39 0584 962313
>>> mob: +39 333 8128928
>>>
>>> http://www.geo-solutions.it
>>> http://geo-solutions.blogspot.com/
>>> http://www.youtube.com/user/GeoSolutionsIT
>>> http://www.linkedin.com/in/andreaaime
>>> http://twitter.com/geowolf
>>>
>>> -------------------------------------------------------
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Benefiting from Server Virtualization: Beyond Initial Workload
>>> Consolidation -- Increasing the use of server virtualization is a top
>>> priority.Virtualization can reduce costs, simplify management, and
>>> improve
>>> application availability and disaster protection. Learn more about
>>> boosting
>>> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
>>> _______________________________________________
>>> Geoserver-users mailing list
>>> Geoserver-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> WhatsUp Gold - Download Free Network Management Software
>> The most intuitive, comprehensive, and cost-effective network
>> management toolset available today. Delivers lowest initial
>> acquisition cost and overall TCO of any competing solution.
>> http://p.sf.net/sfu/whatsupgold-sd
>>
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>
>
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
