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

2015-06-10 Thread 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 michael.smith.e...@gmail.com:
 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.sm...@usace.army.mil




 -Original Message-
 From: Andrea Peri aperi2...@gmail.com
 Date: Wednesday, June 10, 2015 at 5:41 AM
 To: Lime, Steve D (MNIT) steve.l...@state.mn.us
 Cc: mapserver-users@lists.osgeo.org mapserver-users@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.l...@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-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
 Sent: Tuesday, June 09, 2015 3:45 AM
 To: mapserver-users@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@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users





-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

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



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2015-06-10 Thread 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-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
 Gesendet: Dienstag, 9. Juni 2015 23:40
 An: Schylberg Lars; Havard Tveite
 Cc: mapserver-users@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.schylb...@saabgroup.com:
  It seems like You have a typing error.
 
FILTER ([CODICE[ = 107)
 
  Should be:
 
FILTER ([CODICE] = 107)
 
  /Lars
 
  -Original Message-
  From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] On Behalf Of Andrea Peri
  Sent: den 9 juni 2015 11:34
  To: Eichner, Andreas - SID
  Cc: mapserver-users@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.eich...@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-boun...@lists.osgeo.org [mailto:mapserver-users-
  boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
  Gesendet: Dienstag, 9. Juni 2015 10:45
  An: mapserver-users@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@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 
 
  --
  -
  Andrea Peri
  . . . . . . . . .
  qwerty àèìòù
  -
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 
 
 --
 -
 Andrea Peri
 . . . . . . . . .
 qwerty àèìòù
 -
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2015-06-10 Thread 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.e...@gmail.com] 
Sent: Wednesday, June 10, 2015 5:28 AM
To: Andrea Peri; Lime, Steve D (MNIT)
Cc: mapserver-users@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.sm...@usace.army.mil




-Original Message-
From: Andrea Peri aperi2...@gmail.com
Date: Wednesday, June 10, 2015 at 5:41 AM
To: Lime, Steve D (MNIT) steve.l...@state.mn.us
Cc: mapserver-users@lists.osgeo.org mapserver-users@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.l...@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-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
 Sent: Tuesday, June 09, 2015 3:45 AM
 To: mapserver-users@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@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


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

2015-06-09 Thread 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
andreas.eich...@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-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
 Gesendet: Dienstag, 9. Juni 2015 10:45
 An: mapserver-users@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@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2015-06-09 Thread Eichner, Andreas - SID
I think you should use

FILTER ([CODICE] = 107)

i.e. without using FILTERITEM and the leading WHERE

 -Ursprüngliche Nachricht-
 Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
 Gesendet: Dienstag, 9. Juni 2015 10:45
 An: mapserver-users@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@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2015-06-09 Thread Schylberg Lars
It seems like You have a typing error.

  FILTER ([CODICE[ = 107)

Should be:

  FILTER ([CODICE] = 107)

/Lars

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
Sent: den 9 juni 2015 11:34
To: Eichner, Andreas - SID
Cc: mapserver-users@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.eich...@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-boun...@lists.osgeo.org [mailto:mapserver-users- 
 boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
 Gesendet: Dienstag, 9. Juni 2015 10:45
 An: mapserver-users@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@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2015-06-09 Thread Lime, Steve D (MNIT)
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-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
Sent: Tuesday, June 09, 2015 3:45 AM
To: mapserver-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

2015-06-09 Thread Andrea Peri
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.schylb...@saabgroup.com:
 It seems like You have a typing error.

   FILTER ([CODICE[ = 107)

 Should be:

   FILTER ([CODICE] = 107)

 /Lars

 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org 
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
 Sent: den 9 juni 2015 11:34
 To: Eichner, Andreas - SID
 Cc: mapserver-users@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.eich...@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-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
 Gesendet: Dienstag, 9. Juni 2015 10:45
 An: mapserver-users@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@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



 --
 -
 Andrea Peri
 . . . . . . . . .
 qwerty àèìòù
 -
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

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



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users