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

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Andrea Peri
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Eichner, Andreas - SID-NLKM
I think you should use

FILTER "([CODICE] = 107)"

i.e. without using FILTERITEM and the leading WHERE

> -----Ursprüngliche Nachricht-----
> Von: [hidden email] [mailto:mapserver-users-
> [hidden email]] Im Auftrag von Andrea Peri
> Gesendet: Dienstag, 9. Juni 2015 10:45
> An: [hidden email]
> 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
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Andrea Peri
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
<[hidden email]>:

> I think you should use
>
> FILTER "([CODICE] = 107)"
>
> i.e. without using FILTERITEM and the leading WHERE
>
>> -----Ursprüngliche Nachricht-----
>> Von: [hidden email] [mailto:mapserver-users-
>> [hidden email]] Im Auftrag von Andrea Peri
>> Gesendet: Dienstag, 9. Juni 2015 10:45
>> An: [hidden email]
>> 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
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Schylberg Lars
It seems like You have a typing error.

  FILTER "([CODICE[ = 107)"

Should be:

  FILTER "([CODICE] = 107)"

/Lars

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Andrea Peri
Sent: den 9 juni 2015 11:34
To: Eichner, Andreas - SID
Cc: [hidden email]
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
<[hidden email]>:

> I think you should use
>
> FILTER "([CODICE] = 107)"
>
> i.e. without using FILTERITEM and the leading WHERE
>
>> -----Ursprüngliche Nachricht-----
>> Von: [hidden email] [mailto:mapserver-users-
>> [hidden email]] Im Auftrag von Andrea Peri
>> Gesendet: Dienstag, 9. Juni 2015 10:45
>> An: [hidden email]
>> 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
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Lime, Steve D (MNIT)
In reply to this post by Andrea Peri
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: [hidden email] [mailto:[hidden email]] On Behalf Of Andrea Peri
Sent: Tuesday, June 09, 2015 3:45 AM
To: [hidden email]
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Andrea Peri
In reply to this post by Schylberg Lars
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 <[hidden email]>:

> It seems like You have a typing error.
>
>   FILTER "([CODICE[ = 107)"
>
> Should be:
>
>   FILTER "([CODICE] = 107)"
>
> /Lars
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]] On Behalf Of Andrea Peri
> Sent: den 9 juni 2015 11:34
> To: Eichner, Andreas - SID
> Cc: [hidden email]
> 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
> <[hidden email]>:
>> I think you should use
>>
>> FILTER "([CODICE] = 107)"
>>
>> i.e. without using FILTERITEM and the leading WHERE
>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: [hidden email] [mailto:mapserver-users-
>>> [hidden email]] Im Auftrag von Andrea Peri
>>> Gesendet: Dienstag, 9. Juni 2015 10:45
>>> An: [hidden email]
>>> 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
>>> [hidden email]
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
> _______________________________________________
> mapserver-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Andrea Peri
In reply to this post by Lime, Steve D (MNIT)
Hi Steve,

it work.

Many thx for the help.
Now I should change all layers in my mapfile.
To do this, I need to know another question:

is this new sintax supported on mapscript python ?

Thx,

Andrea.


2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) <[hidden email]>:

> 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: [hidden email] [mailto:[hidden email]] On Behalf Of Andrea Peri
> Sent: Tuesday, June 09, 2015 3:45 AM
> To: [hidden email]
> 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
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Eichner, Andreas - SID-NLKM
In reply to this post by Andrea Peri
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: [hidden email] [mailto:mapserver-users-
> [hidden email]] Im Auftrag von Andrea Peri
> Gesendet: Dienstag, 9. Juni 2015 23:40
> An: Schylberg Lars; Havard Tveite
> Cc: [hidden email]
> 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 <[hidden email]>:
> > It seems like You have a typing error.
> >
> >   FILTER "([CODICE[ = 107)"
> >
> > Should be:
> >
> >   FILTER "([CODICE] = 107)"
> >
> > /Lars
> >
> > -----Original Message-----
> > From: [hidden email] [mailto:mapserver-users-
> [hidden email]] On Behalf Of Andrea Peri
> > Sent: den 9 juni 2015 11:34
> > To: Eichner, Andreas - SID
> > Cc: [hidden email]
> > 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
> > <[hidden email]>:
> >> I think you should use
> >>
> >> FILTER "([CODICE] = 107)"
> >>
> >> i.e. without using FILTERITEM and the leading WHERE
> >>
> >>> -----Ursprüngliche Nachricht-----
> >>> Von: [hidden email] [mailto:mapserver-users-
> >>> [hidden email]] Im Auftrag von Andrea Peri
> >>> Gesendet: Dienstag, 9. Juni 2015 10:45
> >>> An: [hidden email]
> >>> 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
> >>> [hidden email]
> >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
> >
> >
> > --
> > -----------------
> > Andrea Peri
> > . . . . . . . . .
> > qwerty àèìòù
> > -----------------
> > _______________________________________________
> > mapserver-users mailing list
> > [hidden email]
> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
> _______________________________________________
> mapserver-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Andrea Peri
In reply to this post by Lime, Steve D (MNIT)
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) <[hidden email]>:

> 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: [hidden email] [mailto:[hidden email]] On Behalf Of Andrea Peri
> Sent: Tuesday, June 09, 2015 3:45 AM
> To: [hidden email]
> 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
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: 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
[hidden email]




-----Original Message-----
From: Andrea Peri <[hidden email]>
Date: Wednesday, June 10, 2015 at 5:41 AM
To: "Lime, Steve D (MNIT)" <[hidden email]>
Cc: "[hidden email]" <[hidden email]>
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) <[hidden email]>:
>> 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: [hidden email]
>>[mailto:[hidden email]] On Behalf Of Andrea Peri
>> Sent: Tuesday, June 09, 2015 3:45 AM
>> To: [hidden email]
>> 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
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
>--
>-----------------
>Andrea Peri
>. . . . . . . . .
>qwerty àèìòù
>-----------------
>_______________________________________________
>mapserver-users mailing list
>[hidden email]
>http://lists.osgeo.org/mailman/listinfo/mapserver-users


_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Andrea Peri
Hi Michael,
thx for your hint.

I do some test.
The right final sintax is this:

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

Thx2all again.

Andrea.




2015-06-10 12:27 GMT+02:00 Michael Smith <[hidden email]>:

> 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
> [hidden email]
>
>
>
>
> -----Original Message-----
> From: Andrea Peri <[hidden email]>
> Date: Wednesday, June 10, 2015 at 5:41 AM
> To: "Lime, Steve D (MNIT)" <[hidden email]>
> Cc: "[hidden email]" <[hidden email]>
> 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) <[hidden email]>:
>>> 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: [hidden email]
>>>[mailto:[hidden email]] On Behalf Of Andrea Peri
>>> Sent: Tuesday, June 09, 2015 3:45 AM
>>> To: [hidden email]
>>> 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
>>> [hidden email]
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>>
>>
>>--
>>-----------------
>>Andrea Peri
>>. . . . . . . . .
>>qwerty àèìòù
>>-----------------
>>_______________________________________________
>>mapserver-users mailing list
>>[hidden email]
>>http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>



--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

Lime, Steve D (MNIT)
In reply to this post by Michael Smith
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:[hidden email]]
Sent: Wednesday, June 10, 2015 5:28 AM
To: Andrea Peri; Lime, Steve D (MNIT)
Cc: [hidden email]
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
[hidden email]




-----Original Message-----
From: Andrea Peri <[hidden email]>
Date: Wednesday, June 10, 2015 at 5:41 AM
To: "Lime, Steve D (MNIT)" <[hidden email]>
Cc: "[hidden email]" <[hidden email]>
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) <[hidden email]>:
>> 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: [hidden email]
>>[mailto:[hidden email]] On Behalf Of Andrea Peri
>> Sent: Tuesday, June 09, 2015 3:45 AM
>> To: [hidden email]
>> 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
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
>--
>-----------------
>Andrea Peri
>. . . . . . . . .
>qwerty àèìòù
>-----------------
>_______________________________________________
>mapserver-users mailing list
>[hidden email]
>http://lists.osgeo.org/mailman/listinfo/mapserver-users


_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users