[mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Rahkonen Jukka (Tike)
Hi, >From document page: http://mapserver.org/mapfile/expressions.html "To use a string comparison for filtering a LAYER, both FILTERITEM and FILTER must be set. FILTERITEM is set to the attribute name. FILTER is set to the value for comparison. The same rule applies to CLASSITEM in the LAYER ob

[mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Robert R. Raiz
Hello Jukka The post from stackexchange was mine. It was at the time when I migrated everything from 5.0 to 6.2 and the docs for 6.2 were not too clear. I too use FILTEITEM when I want to single out something (like the roads from Tiger edges); I am using Mapserver for 4 years now and I still do n

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread TDS
Hello, as far as I know - yes. But you can use expressions with more than one attribute. MfG M. Martin mailto:t...@tds-net.de 1+1=10 You have a ques

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Christy Nieman
You do not need to set both FILTERITEM and FILTER. You can just set FILTER to an expression using as many attributes as you need. e.g. FILTER (( [POPULATION] < 50 ) AND ("[DISPLAY]" == "1")). Just like you can have multiple attributes in a class EXPRESSION. I think it's the section of the

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Rahkonen Jukka (Tike)
Hi, Thank you very much, Christy. By your example I made some tests and now filters like this work for me FILTER (([WORKERS]>2000) OR ("[STATE_FIPS]"="17")) The secret element was the right syntax for string attributes ("[STATE_FIPS]"="17"). Now when I know how it must be used I can find c

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Lime, Steve D (MNIT)
versions. I guess my recommendation would be avoid FILTERs unless you have a good reason to use them. Steve From: mapserver-users-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] on behalf of Rahkonen Jukka (Tike) [jukka.rahko...@mmmtike.fi] Sent: Wednesday, May 14, 2014 8:05

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Steve . Toutant
users-boun...@lists.osgeo.org 2014-05-14 09:05 A "mapserver-users@lists.osgeo.org" cc Objet Re: [mapserver-users] About FILTER and FILTERITEM Hi, Thank you very much, Christy. By your example I made some tests and now filters like this work for me FILTER (([WORKERS]>2000)

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Gregor Karzelek
Hi, As far as I know the Filter is used while data retrieving. At least I have with Postgis and a OSM map FILTER like that: FILTER "type IN ('rail', 'monorail', 'lightrail‘)" This is passed 1:1 to the Postgis data source (I checked that) and thus has a huge performance impact as the complete res

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Steve . Toutant
"Rahkonen Jukka (Tike)" , "mapserver-users@lists.osgeo.org" cc Objet Re: [mapserver-users] About FILTER and FILTERITEM FIlters are used primarily under the hood for certain types of query operations. The main differences are: - FILTERs are defined in the native query

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-14 Thread Rahkonen Jukka (Tike)
second option is a bit more performant, > especially in older versions. I guess my recommendation would be avoid FILTERs > unless you have a good reason to use them. > > Steve > > ____________ > From: mapserver-users-boun...@lists.osgeo.org [mapserver-users-

Re: [mapserver-users] About FILTER and FILTERITEM

2014-05-20 Thread Rahkonen Jukka (Tike)
ss and the second option is a bit more > > performant, especially in older versions. I guess my recommendation > > would be avoid FILTERs unless you have a good reason to use them. > > > > Steve > > > > > > From: mapser