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

[Eichner, Andreas - SID]

It seems the filter expression must not be given as string. So you should use

FILTER ([CODICE] = 107)

Otherwise MapServer will read the filter as string value to be used in combination with FILTERITEM.

> -----Ursprüngliche Nachricht-----
> Von: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-
> bounces at lists.osgeo.org] Im Auftrag von Andrea Peri
> Gesendet: Dienstag, 9. Juni 2015 23:40
> An: Schylberg Lars; Havard Tveite
> Cc: mapserver-users at lists.osgeo.org
> Betreff: Re: [mapserver-users] Incompatibility at Filter - level between
> mapserver 6.x and the last mapserver-dev ?
> 
> Unfortunately no.
> Its only a typo in e-mail.
> 
> The bracket in the mapfile was correct close.
> 
> Thx
> 
> 
> 2015-06-09 12:15 GMT+02:00 Schylberg Lars <lars.schylberg at saabgroup.com>:
> > It seems like You have a typing error.
> >
> >   FILTER "([CODICE[ = 107)"
> >
> > Should be:
> >
> >   FILTER "([CODICE] = 107)"
> >
> > /Lars
> >
> > -----Original Message-----
> > From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-
> bounces at lists.osgeo.org] On Behalf Of Andrea Peri
> > Sent: den 9 juni 2015 11:34
> > To: Eichner, Andreas - SID
> > Cc: mapserver-users at lists.osgeo.org
> > Subject: Re: [mapserver-users] Incompatibility at Filter - level between
> mapserver 6.x and the last mapserver-dev ?
> >
> > Thx for response.
> >
> > I try this,
> >     FILTER "(CODICE = 107)"
> > and also this
> >     FILTER "([CODICE[ = 107)"
> > and removing the filteritem,
> >
> > but still go in error:
> > :(
> >
> > The log report this:
> >
> > [Tue Jun  9 11:29:53 2015].880265 LayerDefaultTranslateFilter():
> > General error message. This data driver does not implement filter
> translation support [Tue Jun  9 11:29:53 2015].955070 msEvalExpression():
> General error message. Cannot evaluate expression, no item index defined.
> >
> > 2015-06-09 11:06 GMT+02:00 Eichner, Andreas - SID
> > <Andreas.Eichner at sid.sachsen.de>:
> >> I think you should use
> >>
> >> FILTER "([CODICE] = 107)"
> >>
> >> i.e. without using FILTERITEM and the leading WHERE
> >>
> >>> -----Ursprüngliche Nachricht-----
> >>> Von: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-
> >>> bounces at lists.osgeo.org] Im Auftrag von Andrea Peri
> >>> Gesendet: Dienstag, 9. Juni 2015 10:45
> >>> An: mapserver-users at lists.osgeo.org
> >>> Betreff: [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
> 
> 
> 
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users