<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi,</p>
<p><br>
</p>
<p>I would recommend to make a test with Mapserver 7.0-beta and GDAL 1.11.2 or at least with 6.4 and 1.10. Your case does feel like an obvious bug but Mapserver 6.0.3 or GDAL 1.8.0 are out of maintenance.</p>
<p><br>
</p>
<p>I have some ideas for workarounds:<br>
</p>
<p>You can try if it makes difference to use either the native PostGIS driver or GDAL OGR driver (CONNECTIONTYPW OGR). You can also try to add
</p>
<p>gml_[item name]_type into the layer metadata <a href="http://mapserver.org/ogc/wfs_server.html">
http://mapserver.org/ogc/wfs_server.html</a> but I do not know if Mapserver 6.0 supports it and probably it does not change anything because your schema is good already. And perhaps using PropertyIsLike instead of PropertyIsEqualTo could work.<br>
</p>
<p><br>
</p>
<p>-Jukka Rahkonen-<br>
</p>
<p><br>
</p>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif">bteluk wrote:</font>
<div> </div>
</div>
<div>I can't shine any light on the problem but I have encountered the same problem. Using MapServer v6.0.3, with Postgres 9.1.3, PostGIS v 1.5.3, GDAL v1.8.0. WFS Posted Query looks like this:
<pre> <wfs:GetFeature service="WFS"
version="1.0.0"
wfs="http://www.opengis.net/wfs"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd">
<wfs:Query typeName="PostCodeArea">
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>pcode</ogc:PropertyName>
<ogc:Literal>3168</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
</wfs:Query>
</wfs:GetFeature>
</pre>
The DescribeFeatureType for that layer shows the following for the attribute:
<pre><element name="pcode" type="string"/>
</pre>
PostgreSQL has the attribute field specified as a string:
<pre>pcode | character varying(10) |
</pre>
Server responds:
<pre><?xml version='1.0' encoding="ISO-8859-1" ?>
<ServiceExceptionReport version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc http://schemas.opengis.net//wfs/1.0.0/OGC-exception.xsd">
<ServiceException code="NoApplicableCode" locator="mapserv">
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: operator does not exist: character varying = integer
LINE 1: ...90 -5,165 -5,165 -50,90 -50))',4283) and ( ("pcode"= 3168) )
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
</ServiceException>
</ServiceExceptionReport>
</pre>
Postgres Log shows:
<pre>2015-02-27 16:11:42.394 EST gecli 127.0.0.1(41368)ERROR: operator does not exist: character varying = integer at character 250
2015-02-27 16:11:42.394 EST gecli 127.0.0.1(41368)HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2015-02-27 16:11:42.394 EST gecli 127.0.0.1(41368)STATEMENT: select "gid","source","ufi","area","pcode","perimeter",encode(ST_AsBinary(ST_Force_2D("the_geom"),'NDR'),'hex') as geom,"gid" from sensis.postcode where the_geom && ST_GeomFromText('POLYGON((90 -50,90 -5,165 -5,165 -50,90 -50))',4283) and ( ("pcode"= 3168) )
$
</pre>
Certainly appears that the query put to PostGIS is incorrect - it's not quoting the literal value. I have a similar MapServer layer that's based on ESRI Shapefile - same effective attribute set up, and it works fine - of course it's not going via PostgreSQL/PostGIS
- so it seems that the problem is specific to the PostgreSQL/PostGIS interface? I tried mucking around with including PostgreSQL casts on the literal eg. "3168::text", using "CAST(pcode as int)" on the PropertyName etc with no luck. Using "PropertyIsLike"
did work, but is not an ideal solution. <br>
<hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/WFS-filter-creates-a-query-using-a-number-instead-of-text-tp5130361p5190393.html">
Re: WFS filter creates a query using a number instead of text</a><br>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html">
Mapserver - User mailing list archive</a> at Nabble.com.<br>
</div>
</div>
</body>
</html>