<div dir="ltr">Hi Steve,<div><br></div><div>thank you for the quckly response!!</div><div><br></div><div>I've just tried to change my request using you suggestion ... this is the new request now ..<br><div><br></div><div><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.1.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=">http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.1.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=</a><ogc:Filter xmlns:ogc="<a href="http://www.opengis.net/ogc">http://www.opengis.net/ogc</a>"><ogc:PropertyIsLike matchCase="false" wildCard="*" singleChar="." escapeChar="!"><ogc:PropertyName>id</ogc:PropertyName><ogc:Literal>*13800000050414*</ogc:Literal></ogc:PropertyIsLike></ogc:Filter> <br></div></div><div><br></div><div>or better how it's used in my browser</div><div><br></div><div><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.1.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%20xmlns:ogc=%22http://www.opengis.net/ogc%22%3E%3Cogc:PropertyIsLike%20matchCase=%22false%22%20wildCard=%22*%22%20singleChar=%22.%22%20escapeChar=%22!%22%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*13800073301968*%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E">http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.1.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%20xmlns:ogc=%22http://www.opengis.net/ogc%22%3E%3Cogc:PropertyIsLike%20matchCase=%22false%22%20wildCard=%22*%22%20singleChar=%22.%22%20escapeChar=%22!%22%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*13800073301968*%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E</a><br></div><div><br></div><div>Unfortunately still doesn't work .... No data received is the response .... </div><div><br></div><div>Cesare</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Cesare Gerbino<br><br><a href="http://cesaregerbino.wordpress.com/" target="_blank">http://cesaregerbino.wordpress.com/</a><br><a href="http://www.facebook.com/cesare.gerbino" target="_blank">http://www.facebook.com/cesare.gerbino</a><br><a href="http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl" target="_blank">http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl</a><br><a href="https://twitter.com/CesareGerbino" target="_blank">https://twitter.com/CesareGerbino</a><br><a href="http://www.linkedin.com/pub/cesare-gerbino/56/494/77b" target="_blank">http://www.linkedin.com/pub/cesare-gerbino/56/494/77b</a></div><div><br></div><div><span style="color:rgb(85,85,85);font-family:Verdana,'BitStream vera Sans',Helvetica,sans-serif;font-size:12px;line-height:17.3999996185303px">Questo è un account di posta personale di Cesare Gerbino: tutte le opinioni espresse sono p</span><span style="color:rgb(85,85,85);font-family:Verdana,'BitStream vera Sans',Helvetica,sans-serif;font-size:12px;line-height:17.3999996185303px">ersonali e non riflettono necessariamente quelle del mio datore di lavoro</span></div><div><span style="color:rgb(85,85,85);font-family:Verdana,'BitStream vera Sans',Helvetica,sans-serif;font-size:12px;line-height:17.3999996185303px"><br></span></div><div><span style="color:rgb(85,85,85);font-family:Verdana,'BitStream vera Sans',Helvetica,sans-serif;font-size:12px;line-height:17.3999996185303px">This is Cesare Gerbino mail account. Text is written by Cesare Gerbino:  the views expressed  are mine and not necessarily those of my employer.</span><span style="color:rgb(85,85,85);font-family:Verdana,'BitStream vera Sans',Helvetica,sans-serif;font-size:12px;line-height:17.3999996185303px"><br></span></div><div><span style="color:rgb(85,85,85);font-family:Verdana,'BitStream vera Sans',Helvetica,sans-serif;font-size:12px;line-height:17.3999996185303px">.</span><br><br></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">2015-05-12 21:48 GMT+02:00  <span dir="ltr"><<a href="mailto:Steve.Toutant@inspq.qc.ca" target="_blank">Steve.Toutant@inspq.qc.ca</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><font size="2" face="sans-serif">Your syntax are good. This is an old problem
with int considered as string</font>
<br><font size="2" face="sans-serif">Using </font><font size="1" color="#2f2f2f" face="DejaVu Sans Mono">ogc:PropertyIsLike
</font><font size="2" face="sans-serif">works though, here is a request</font>
<br>
<br><font size="1" color="#2f2f2f" face="DejaVu Sans Mono"><ogc:Filter xmlns:ogc="</font><a href="http://www.opengis.net/ogc" target="_blank"><font size="1" color="blue" face="DejaVu Sans Mono">http://www.opengis.net/ogc</font></a><font size="1" color="#2f2f2f" face="DejaVu Sans Mono">"><ogc:PropertyIsLike
matchCase="false" wildCard="*" singleChar="."
escapeChar="!"><ogc:PropertyName>id</ogc:PropertyName><ogc:Literal>*13800073301968*</ogc:Literal></ogc:PropertyIsLike></ogc:Filter></font><font size="3">
</font>
<br>
<br><font size="2" face="sans-serif">Also this wfs support version= 1.1.0,
you should do your request by specifying this version</font>
<p>
<br>
<br>
<br>
</p><p></p><table width="100%" style="border-collapse:collapse">
<tbody><tr valign="top" height="8">
<td width="40%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px"><font size="1" face="sans-serif"><b>cesare
gerbino <<a href="mailto:cesaregerbino@gmail.com" target="_blank">cesaregerbino@gmail.com</a>>@<a href="http://lists.osgeo.org" target="_blank">lists.osgeo.org</a></b> </font>
<br><font size="1" face="sans-serif">Envoyé par : <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a></font>
<p><font size="1" face="sans-serif">2015-05-12 15:33</font>
</p></td><td width="59%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px">
<table width="100%" style="border-collapse:collapse">
<tbody><tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px"><font size="1" face="sans-serif"><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a></font>
</td></tr><tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px">
</td></tr><tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px"><font size="1" face="sans-serif">[mapserver-users]
How to use filter encoding in MapServer in a WFS        query?</font></td></tr></tbody></table>
<br>
<table width="393" style="border-collapse:collapse">
<tbody><tr valign="top" height="8">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px">
</td><td width="336" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br>
<br>
<br>
<br>
<br><font size="3">Hi all!</font>
<br>
<br><font size="3">I need to query this WFS public service </font>
<br>
<br><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&service=wfs&request=getCapabilities" target="_blank"><font size="3" color="blue"><u>http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&service=wfs&request=getCapabilities</u></font></a>
<br>
<br><font size="3">The layer I need to query is this one</font>
<br>
<br><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&service=wfs&version=1.0.0&request=DescribeFeatureType" target="_blank"><font size="3" color="blue"><u>http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&service=wfs&version=1.0.0&request=DescribeFeatureType</u></font></a>
<br>
<br><font size="3">It's a layer with a very big number of point features.</font>
<br>
<br><font size="3">The OGC service is done using MapServer but I don't know
the version.</font>
<br>
<br><font size="3">I need to query this layer in a no spatial way: the simplest
query I need to do is something like this one</font>
<br>
<br><font size="3">    </font><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=" target="_blank"><font size="3" color="blue"><u>http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=</u></font></a><font size="3"><Filter><PropertyIsEqualTo><PropertyName>id</PropertyName><Literal>13800000050414</Literal></PropertyIsEqualTo></Filter></font>
<br>
<br><font size="3">My final query would like to combine several clauses using
the AND logical operator.</font>
<br>
<br><font size="3">Unfortunately at the moment the simplest query above doesn't
work: if you try it in the response ther will be something like </font>
<br>
<br><font size="3">HINT: No operator matches the given name and argument
type(s). You might need to add explicit type casts</font>
<br>
<br><font size="3">I've done several attempts to change it and I've tried
other queries: for example</font>
<br>
<br><font size="3">1) this one ...</font>
<br>
<br><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsEqualTo%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%2713800000050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsEqualTo%3E%3C/ogc:Filter%3E" target="_blank"><font size="3" color="blue"><u>http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsEqualTo%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%2713800000050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsEqualTo%3E%3C/ogc:Filter%3E</u></font></a>
<br>
<br>
<br><font size="3">returns </font>
<br>
<br><font size="3">    <gml:boundedBy><gml:null>missing</gml:null></gml:boundedBy></font>
<br>
<br><font size="3">so I think that in this case the sintax could be right
but I'm not sure and I don0't understand because the response is null </font>
<br>
<br><font size="3">2) trying to do a spatial query like this one ...</font>
<br>
<br><font size="3">    </font><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3CFilter%3E%3CBBOX%3E%3CPropertyName%3EName%3ENAME%3C/PropertyName%3E%3CBox%20srsName=%27EPSG:4326%27%3E%3Ccoordinates%3E7.626630,45.029061%207.673107,45.052713%3C/coordinates%3E%3C/Box%3E%3C/BBOX%3E%3C/Filter%3E" target="_blank"><font size="3" color="blue"><u>http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3CFilter%3E%3CBBOX%3E%3CPropertyName%3EName%3ENAME%3C/PropertyName%3E%3CBox%20srsName=%27EPSG:4326%27%3E%3Ccoordinates%3E7.626630,45.029061%207.673107,45.052713%3C/coordinates%3E%3C/Box%3E%3C/BBOX%3E%3C/Filter%3E</u></font></a>
<br>
<br><font size="3">returns a right response.</font>
<br>
<br><font size="3">I've found on the web that probably there is a workaround
...</font>
<br>
<br><a href="http://osgeo-org.1560.x6.nabble.com/WFS-filter-creates-a-query-using-a-number-instead-of-text-td5130361.html#a5190402" target="_blank"><font size="3" color="blue"><u>http://osgeo-org.1560.x6.nabble.com/WFS-filter-creates-a-query-using-a-number-instead-of-text-td5130361.html#a5190402</u></font></a>
<br>
<br><font size="3">that suggest to use the PropertyIsLike operator instead
of the PropertyIsEqual. I've tried to use it but it doesn't work in my
case ... </font>
<br>
<br><a href="http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsLike%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%2713800000050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E" target="_blank"><font size="3" color="blue"><u>http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsLike%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%2713800000050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E</u></font></a>
<br>
<br><font size="3">in this case after a long time it seems that the service
goes in time out and no data is returned .... </font>
<br>
<br><font size="3">Now I am completely blocked .... :-(</font>
<br>
<br><font size="3">Any suggestions / workaround? </font>
<br>
<br><font size="3">Thank you very much in advance ...</font>
<br>
<br><font size="3">Cesare</font>
<br>
<br><font size="3">Cesare Gerbino<br>
</font><font size="3" color="blue"><u><br>
</u></font><a href="http://cesaregerbino.wordpress.com/" target="_blank"><font size="3" color="blue"><u>http://cesaregerbino.wordpress.com/</u></font></a><font size="3" color="blue"><u><br>
</u></font><a href="http://www.facebook.com/cesare.gerbino" target="_blank"><font size="3" color="blue"><u>http://www.facebook.com/cesare.gerbino</u></font></a><font size="3" color="blue"><u><br>
</u></font><a href="http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl" target="_blank"><font size="3" color="blue"><u>http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl</u></font></a><font size="3" color="blue"><u><br>
</u></font><a href="https://twitter.com/CesareGerbino" target="_blank"><font size="3" color="blue"><u>https://twitter.com/CesareGerbino</u></font></a><font size="3" color="blue"><u><br>
</u></font><a href="http://www.linkedin.com/pub/cesare-gerbino/56/494/77b" target="_blank"><font size="3" color="blue"><u>http://www.linkedin.com/pub/cesare-gerbino/56/494/77b</u></font></a>
<br>
<br><font size="1" color="#4f4f4f" face="Verdana">Questo è un account di posta
personale di Cesare Gerbino: tutte le opinioni espresse sono personali
e non riflettono necessariamente quelle del mio datore di lavoro</font>
<br>
<br><font size="1" color="#4f4f4f" face="Verdana">This is Cesare Gerbino mail
account. Text is written by Cesare Gerbino:  the views expressed  are
mine and not necessarily those of my employer.</font>
<br><font size="1" color="#4f4f4f" face="Verdana">.</font><font size="3"><br>
</font><tt><font size="2">_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
</font></tt><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank"><tt><font size="2">http://lists.osgeo.org/mailman/listinfo/mapserver-users</font></tt></a>
<br>
<br>
<br><p></p></blockquote></div><br></div>