FILTER slow

Andreas Albarello andreas.albarello at TERRITORIUMONLINE.COM
Thu Sep 13 07:00:29 EDT 2007


Stephan Holl wrote:
>>
>> FILTER ([adr_id] IN '6446,6366,6483,...')
> 
> Thanks for the tip, but unfortunately it does not solve my problem. The
> filter does not get applied, it does not show up at all with your
> syntax above.

That's weird, this should indeed work and was confirmed the other day by 
Lars-Göran Edholm on this mailing list. What Mapserver version are 
working on? This is a shapefile layer, right? Are you sure you've got it 
right? Notice the quotes around the comma-separated values (no space 
between the values)! You could also try to do a string comparison which 
might be necessary if adr_id is not a purely numerical field:

FILTER ('[adr_in]' IN '6446,6366,6483')

In this case you just quote the field as well.

HTH,
-- 
--------------------------------------------------------------------
Andreas Albarello
Analysis & SW Development

Territorium Online srl/GmbH
Via Buozzi/Buozzistraße 12 - I 39100 Bolzano/Bozen
email: andreas.albarello at territoriumonline.com
web:   www.territoriumonline.com
--------------------------------------------------------------------



More information about the mapserver-users mailing list