[mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

[Michael Smith]

Andrea,

You can always use your existing filters with

PROCESSING "NATIVE_FILTER=WHERE (ANNO = 2006) and (CODICE_UNIVOCO like
'%idtpn%' )"

Or you can use a MapServer expression which are documented here:
http://mapserver.org/mapfile/expressions.html#mapserver-expressions

Mike

----
Michael Smith

US Army Corps
Remote Sensing GIS/Center
michael.smith at usace.army.mil




-----Original Message-----
From: Andrea Peri <aperi2007 at gmail.com>
Date: Wednesday, June 10, 2015 at 5:41 AM
To: "Lime, Steve D (MNIT)" <Steve.Lime at state.mn.us>
Cc: "mapserver-users at lists.osgeo.org" <mapserver-users at lists.osgeo.org>
Subject: Re: [mapserver-users] Incompatibility at Filter - level between
mapserver 6.x and the last mapserver-dev ?

>Hi steve,
>this new sintax will allow the AND operator ?
>
>I have a filter like this:
>
>FILTER "WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' )"
>
>and don't know how to transform it with the new sintax.
>
>Is this kind of filter supported ?
>
>Thx,
>
>A.
>
>
>2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) <Steve.Lime at state.mn.us>:
>> As of MapServer 7.0 FILTERS must be given using MapServer syntax - this
>>is a regression noted in the Migration Guide, see
>>http://mapserver.org/MIGRATION_GUIDE.html#migration. There's an OGR
>>example right towards the top of that document. Basically:
>>
>>   FILTER "WHERE ([CODICE] = 107)"
>>   FILTERITEM "CODICE"
>>
>> Becomes:
>>
>>   PROCESSING 'NATIVE_FILTER=CODICE=107'
>>
>> Steve
>>
>> -----Original Message-----
>> From: mapserver-users-bounces at lists.osgeo.org
>>[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Andrea Peri
>> Sent: Tuesday, June 09, 2015 3:45 AM
>> To: mapserver-users at lists.osgeo.org
>> Subject: [mapserver-users] Incompatibility at Filter - level between
>>mapserver 6.x and the last mapserver-dev ?
>>
>> Hi,
>> I have just update my mapserver to the last mapserver-dev .
>>
>> After this update, I see an error on the filtering.
>>
>> In my mapfile the data configuration was originally this:
>>
>>     CONNECTION "/path-to-spatialite-db/zz_db_tematici.sqlite"
>>     CONNECTIONTYPE OGR
>>     DATA "IFT2009"
>>     EXTENT 1554650.74 4678225.52 1771822.76 4924891.9
>>     FILTER "WHERE ([CODICE] = 107)"
>>     FILTERITEM "CODICE"
>>       ....
>>
>>
>> The log report this error:
>>
>> [Tue Jun  9 10:39:46 2015].153296 msDrawMap(): rendering using
>> outputformat named AGGA (AGG/PNG).
>> [Tue Jun  9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and
>>query, 0.001s
>> [Tue Jun  9 10:39:46 2015].262330 LayerDefaultTranslateFilter():
>> General error message. This data driver does not implement filter
>> translation support
>> [Tue Jun  9 10:39:46 2015].282402 msDrawMap(): Layer 239
>> (rt_ucs.idift.rt.107), 0.128s
>> [Tue Jun  9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache,
>>0.000s
>>
>> I'm using spatialite as db.
>>
>> After this error, I read this RFC:
>> http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html
>>
>> And try the new settings,
>>
>>     FILTER (([FILTERITEM[ = "string") AND (CODICE = 107))
>>
>> but it seem don't work.
>>
>> I don't understand if this is an issue of the new settings with
>> spatialite or I'm wrong something.
>>
>> Thx,
>>
>>
>> --
>> -----------------
>> Andrea Peri
>> . . . . . . . . .
>> qwerty àèìòù
>> -----------------
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
>-- 
>-----------------
>Andrea Peri
>. . . . . . . . .
>qwerty àèìòù
>-----------------
>_______________________________________________
>mapserver-users mailing list
>mapserver-users at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/mapserver-users