<div dir="ltr"><div>Still no success with reproducing this case. Just a thought: you're filtering on propertyname 'number' which is an alias for kc_broj. 'number' is not listed in gml_include_items. What about putting 'kc_broj as number' into the select statement and/or adding 'number' to gml_include_items?<br>
<br></div>Kind regards, Martin.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-02-20 15:06 GMT+01:00 Dejan Gambin <span dir="ltr"><<a href="mailto:dejan.gambin@coin.hr" target="_blank">dejan.gambin@coin.hr</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Here are some parts:<div><br></div><div><div>WEB</div><div> TEMPLATE "map.html"</div>
<div> IMAGEPATH "/var/www/tmp/"</div><div> IMAGEURL "/tmp/"</div><div> METADATA</div><div> "wms_encoding" "UTF-8"</div><div> "wms_title" "WMS Demo Server"</div>
<div> "wms_online_resource" "<a href="http://my.site.com/cgi-bin/mywms6?" target="_blank">http://my.site.com/cgi-bin/mywms6?</a>"</div><div> "wms_srs" "EPSG:900913 EPSG:31275 EPSG:4326 EPSG:4269 EPSG:3857"</div>
<div> "wms_feature_info_mime_type" "text/html" </div><div> "wfs_encoding" "UTF-8"</div><div> "wfs_title" "WFS Demo Server"</div><div> "wfs_namespace_prefix" "coin"</div>
<div> "wfs_abstract" "WFS Demo Server Description" </div><div> "wfs_namespace_uri" "<a href="http://my.site.com" target="_blank">http://my.site.com</a>"</div><div> "wfs_online_resource" "<a href="http://my.site.com/cgi-bin/mywfs6" target="_blank">http://my.site.com/cgi-bin/mywfs6</a>?"</div>
<div> "wfs_srs" "EPSG:900913 EPSG:31275 EPSG:4326 EPSG:4269 EPSG:3857"</div><div> "ows_enable_request" "*" </div><div> END</div><div>END # Web</div><div><br></div><div><br>
</div><div><br></div><div><div>LAYER</div><div> NAME "layer_name"</div><div> STATUS ON</div><div> CONNECTIONTYPE POSTGIS</div><div> CONNECTION "host=localhost user=username password=password dbname=db_name port=5432"</div>
<div> DATA "the_geom from (select gid, the_geom, kc_broj, povrsina, vlasnistv2, vlasnici from table_view) as subquery using unique gid using srid=31275"</div><div> TYPE POLYGON </div><div> GROUP "layer_group"</div>
<div> PROJECTION</div><div> "init=epsg:31275"</div><div> END </div><div> METADATA </div><div> "DESCRIPTION" "Ownership map"</div><div> "wms_title" "VLASNICKA KARTA"</div>
<div> "wms_srs" "EPSG:31275" </div><div> "wfs_title" "VLASNICKA KARTA" </div><div> "wfs_srs" "EPSG:31275" </div><div> "gml_include_items" "kc_broj,povrsina,vlasnistv2,vlasnici"</div>
<div> "gml_kc_broj_alias" "NUMBER"</div><div> "gml_povrsina_alias" "AREA" </div><div> "gml_vlasnistv2_alias" "OWNERSHIP"</div><div> "gml_vlasnici_alias" "OWNERS" </div>
<div> "wms_include_items" "all" </div><div> END</div><div> CLASSITEM 'vlasnistv2'</div><div> LABELITEM "kc_broj"</div><div> PROCESSING "LABEL_NO_CLIP=ON" </div><div>
LABELMAXSCALEDENOM 10000</div><div> CLASS</div></div><div> etc.</div><div> etc.</div><div><div> TRANSPARENCY 70</div><div> DUMP TRUE</div><div>END </div></div><div><br></div><div>Thx very much, I'll try with another layer also </div>
<span class="HOEnZb"><font color="#888888"><div><br></div><div>dejan</div></font></span><div><div class="h5"><div><br></div><div><div>On 20. vel. 2014., at 14:50, Martin Kofahl wrote:</div><br><blockquote type="cite"><div dir="ltr">
Hi Dejan,<br>I cannot reproduce this error, so far. I tried 6.4.1 and the current master and did filter on numeric and text columns. Can you provide a shortened mapfile to reproduce this case?<br><div class="gmail_extra">
<br></div><div class="gmail_extra">Martin<br></div><div class="gmail_extra"><br><div class="gmail_quote">2014-02-19 10:38 GMT+01:00 Dejan Gambin <span dir="ltr"><<a href="mailto:dejan.gambin@coin.hr" target="_blank">dejan.gambin@coin.hr</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Sure, here you are:<div><br></div><div>1.0.0 (working) request:</div><div><br></div>
<div>
WFS post request: <wfs:GetFeature xmlns:wfs="<a href="http://www.opengis.net/wfs" target="_blank">http://www.opengis.net/wfs</a>" service="WFS" version="1.0.0" maxFeatures="100" xsi:schemaLocation="<a href="http://www.opengis.net/wfs" target="_blank">http://www.opengis.net/wfs</a> <a href="http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd" target="_blank">http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"><wfs:Query typeName="ms:katastar_vodnjan_poligon" xmlns:ms="<a href="http://gis.kermas-istra.com/" target="_blank">http://gis.kermas-istra.com</a>"><ogc:Filter xmlns:ogc="<a href="http://www.opengis.net/ogc" target="_blank">http://www.opengis.net/ogc</a>"><ogc:PropertyIsLike wildCard="*" singleChar="." escape="!"><ogc:PropertyName>NUMBER</ogc:PropertyName><ogc:Literal>19/1</ogc:Literal></ogc:PropertyIsLike></ogc:Filter></wfs:Query></wfs:GetFeature></div>
<div><br></div><div><div>1.1.0 (non-working) request:</div><div><br></div><div>WFS post request: <wfs:GetFeature xmlns:wfs="<a href="http://www.opengis.net/wfs" target="_blank">http://www.opengis.net/wfs</a>" service="WFS" version="1.1.0" maxFeatures="100" xsi:schemaLocation="<a href="http://www.opengis.net/wfs" target="_blank">http://www.opengis.net/wfs</a> <a href="http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" target="_blank">http://schemas.opengis.net/wfs/1.1.0/wfs.xsd</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"><wfs:Query typeName="ms:katastar_vodnjan_poligon" srsName="EPSG:900913" xmlns:ms="<a href="http://gis.kermas-istra.com/" target="_blank">http://gis.kermas-istra.com</a>"><ogc:Filter xmlns:ogc="<a href="http://www.opengis.net/ogc" target="_blank">http://www.opengis.net/ogc</a>"><ogc:PropertyIsLike wildCard="*" singleChar="." escapeChar="!"><ogc:PropertyName>NUMBER</ogc:PropertyName><ogc:Literal>19/1</ogc:Literal></ogc:PropertyIsLike></ogc:Filter></wfs:Query></wfs:GetFeature></div>
</div><div><br></div><div>thanks, dejan</div><div><div><div><br><div><div>On 19. vel. 2014., at 08:57, Martin Kofahl wrote:</div><br><blockquote type="cite"><div dir="ltr"><div><div>Hi Dejan,<br></div>can you please post the get or post request made by openlayers for both, version 1.1.0 and 1.0.0?<br>
<br></div>Martin<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2014-02-18 11:37 GMT+01:00 Dejan Gambin <span dir="ltr"><<a href="mailto:dejan.gambin@coin.hr" target="_blank">dejan.gambin@coin.hr</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I have been using MapServer 6.0.3 for a while. My client application worked well with WFS 1.1.0 protocol. Here is the part of the code:<br>
<br>
var protocol = new OpenLayers.Protocol.WFS({<br>
version: "1.0.0",<br>
url: self.options.config.wfs_url + "SERVICE=WFS&srsName=EPSG:900913",<br>
srsName:"EPSG:900913",<br>
featureNS: self.options.config.wfs_ns,<br>
geometryName: "msGeometry",<br>
featurePrefix: "ms",<br>
featureType: some_layer,<br>
defaultFilter: new OpenLayers.Filter.Comparison({<br>
type: OpenLayers.Filter.Comparison.LIKE,<br>
property: some_property<br>
value: some_value<br>
})<br>
})<br>
<br>
Recently I went to MapServer 6.4.1 and I started to get "no results" when using this code to search by attributes. I changed version 1.1.0 to 1.0.0 and everything works fine now.<br>
<br>
Does anyone know what is the reason for this and should I stay on 1.0.0?<br>
<br>
Notes - when doing spatial query it works ok even with 1.1.0.<br>
<br>
Thanks!<br>
<br>
dejan<br>
<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</blockquote></div><br></div>
_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></blockquote>
</div><br></div></div></div></div></blockquote></div><br></div></div>
_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></blockquote>
</div><br></div></div></div></div></blockquote></div><br></div>