Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?
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 ?
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 ?
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 ?
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 ?
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 ?
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 ?
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 ?
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 ?
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 ?
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