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

[Lime, Steve D (MNIT)]

Correct. Filters specified in this manner are passed directly to the underlying driver. My goal was to remove ambiguity with the FILTER keyword itself since it could take both MapServer syntax and native driver syntax - depending on context. --Steve

-----Original Message-----
From: Michael Smith [mailto:michael.smith.erdc at gmail.com] 
Sent: Wednesday, June 10, 2015 5:28 AM
To: Andrea Peri; Lime, Steve D (MNIT)
Cc: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

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