this is weird..... First, DescribeFeatureType returns string for every attributes <element name="LONG_STAT" minOccurs="0" type="string"/>
Here is a getfeature response ( http:/xxxxx?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=feature:SMDVDP_STAT_METE&maxFeatures=5 ) <ms:LONG_STAT>-65,6906</ms:LONG_STAT> Using ogc:PropertyIsEqualTo matchCase="true" <ogc:Literal>-61, 8031</ogc:Literal> it crashes Using ogc:PropertyIsEqualTo matchCase="true" <ogc:Literal>-61. 8031</ogc:Literal> it works Using ogc:PropertyIsEqualTo matchCase="false" <ogc:Literal>-61. 8031</ogc:Literal> it crashes So getfeature returns "," as decimals separator, but getfeature with a filter needs a "." to works, but with matchCase=false crashes in any case..... I'm totally confuse "Rahkonen Jukka (MML)" <jukka.rahko...@maanmittauslaitos.fi> 2015-05-13 10:46 A "steve.tout...@inspq.qc.ca" <steve.tout...@inspq.qc.ca> cc MapserverList OSGEO <mapserver-users@lists.osgeo.org> Objet VS: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field Hi, What does the schema of the feature type show if you check it with DescribeFeatureType? If the property is String I think you should stop what you do and make Mapserver to consider and announce the property as numeric first. -Jukka Rahkonen- steve.tout...@inspq.qc.ca wrote: this works <ogc:PropertyIsLike matchCase="true" wildCard="*" singleChar="." escapeChar="!"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>*-61,8031*</ogc:Literal></ogc:PropertyIsLike> But we want to be able to usePropertyIsEqual because are end users won't use PropertyIsLike... thomas bonfort <thomas.bonf...@gmail.com> 2015-05-13 05:40 A steve.tout...@inspq.qc.ca cc MapserverList OSGEO <mapserver-users@lists.osgeo.org> Objet Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field can you try the same request without the "matchCase" part and report back please? On 12 May 2015 at 18:11, <steve.tout...@inspq.qc.ca> wrote: > I have a problem using a FILTER in a wfs getFeature request on an oracle DB > with MS7 > When I launch a getFeature request with a Filter on a numeric field it > doesn't work, > <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc "><ogc:PropertyIsEqualTo > matchCase="false"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter> > here is the error we get in the browser > <ows:Exception exceptionCode="NoApplicableCode" locator="mapserv"> > <ows:ExceptionText>msWFSGetFeature(): WFS server error. > FLTApplyFilterToLayer() failed > msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data > statement and server logs</ows:ExceptionText> > > from mapserver logs > [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter. > String: ([LONG_STAT] =*-61) > > LONG_STAT is a NUMBER in the DB > DescribefeatureType returns > <element name="NO_STAT_CLIM" minOccurs="0" type="string"/> > <element name="NO_STAT_FADQ" minOccurs="0" type="string"/> > <element name="NOM_STAT" minOccurs="0" type="string"/> > <element name="LATI_STAT" minOccurs="0" type="string"/> > <element name="LONG_STAT" minOccurs="0" type="string"/> > <element name="ALTI_STAT" minOccurs="0" type="string"/> > > I tried to add "gml_types" "auto" in the mapfile, but it still returns > string as data type > I tried "gml_LONG_STAT_type" = "Integer" in the mapfile, describeFeatureType > returns "<element name="LONG_STAT" minOccurs="0" type="double"/> " but I > still get an error in getFeature > > I'm using CONNECTIONTYPE oraclespatial in the mapfile > > I can provide more information.... > > Is it a known issue or can I do something about that? > > Thank you! > _______________________________________________ > 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
