mmh...<br><br>Hi,<br><br>'m try-ing to check the logical operator but they don't seem work.<br><br>If the AND operator is supported this mean that I'm wrong something.<br><br>This request will get the results from a query with filter NAME="FIRENZE".<br>
<br><a href="http://web.regione.toscana.it/wfsvector/com.rt.wfs.RTmap/wfs?service=WFS&version=1.1.0&request=GetFeature&typename=infrastrutture:rt_infr_idstrade_rt_bb&propertyName=geometry,dug,toponimo,den_estesa,tipo_prop,cod_istat,comune&sortBy=dug+A,toponimo+A&Filter=%3CFilter%20xmlns:wfs=%22http://www.opengis.net/wfs%22%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecomune%3C/PropertyName%3E%3CLiteral%3EFIRENZE%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3C/Filter%3E">http://web.regione.toscana.it/wfsvector/com.rt.wfs.RTmap/wfs?service=WFS&version=1.1.0&request=GetFeature&typename=infrastrutture:rt_infr_idstrade_rt_bb&propertyName=geometry,dug,toponimo,den_estesa,tipo_prop,cod_istat,comune&sortBy=dug+A,toponimo+A&Filter=%3CFilter%20xmlns:wfs=%22http://www.opengis.net/wfs%22%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecomune%3C/PropertyName%3E%3CLiteral%3EFIRENZE%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3C/Filter%3E</a><br>
<br>And the logs report correctly the filter used:<br><br>[Sun Oct 14 11:51:50 2012] [SQL] SELECT ST_xmin(g.extent), ST_ymin(g.extent), ST_xmax(g.extent), ST_ymax(g.extent) FROM (SELECT ST_Extent(foo.the_geom) as extent FROM ( (SELECT ST_Transform("geometry"::geometry, 3003) AS "the_geom" FROM iternet."itnt_stradebb" WHERE "comune" = 'FIRENZE' ORDER BY "dug" ASC,"toponimo" ASC LIMIT 500) ) AS foo) AS g<br>
<br><br>Now I try to call the same request with a double filter:<br>NAME="FIRENZE" AND TIPO_PROP="Comune"<br><br>I build it following a sample from mapserver docs.<br><br><a href="http://web.regione.toscana.it/wfsvector/com.rt.wfs.RTmap/wfs?service=WFS&version=1.1.0&request=GetFeature&typename=infrastrutture:rt_infr_idstrade_rt_bb&propertyName=geometry,dug,toponimo,den_estesa,tipo_prop,cod_istat,comune&sortBy=dug+A,toponimo+A&Filter=">http://web.regione.toscana.it/wfsvector/com.rt.wfs.RTmap/wfs?service=WFS&version=1.1.0&request=GetFeature&typename=infrastrutture:rt_infr_idstrade_rt_bb&propertyName=geometry,dug,toponimo,den_estesa,tipo_prop,cod_istat,comune&sortBy=dug+A,toponimo+A&Filter=</a><Filter xmlns:wfs="<a href="http://www.opengis.net/wfs">http://www.opengis.net/wfs</a>"><AND><PropertyIsEqualTo><PropertyName>comune</PropertyName><Literal>FIRENZE</Literal></PropertyIsEqualTo><PropertyIsEqualTo><PropertyName>tipo_prop</PropertyName><Literal>Comune</Literal></PropertyIsEqualTo></AND></Filter><br>
<br>But this request don't return any results.<br>Seeing the log it report that the query has the "where" filter empty:<br><br>[Sun Oct 14 11:55:38 2012] [SQL] SELECT "ogc_fid",ST_AsGML(3, ST_Transform("geometry"::geometry,3003),8, 23) AS "geometry" ,"col_0","cod_top","comune","siglaprov","cod_com","cod_istat","dug","toponimo","cod_reg","den_estesa","tip_prp","tipo_prop","cod_prp","cls_amm","den_breve","data_elab" FROM iternet."itnt_stradebb" WHERE ORDER BY "dug" ASC,"toponimo" ASC LIMIT 500<br>
<br>so nothing is find.<br><br>If the AND operator is supported from TinyOWS, this mean that I'm wrong something else.<br><br>Any hint is welcome<br><br>Thx,<br><br>Andrea.<br><br><div class="gmail_quote">2012/10/14 Olivier Courtin <span dir="ltr"><<a href="mailto:olivier.courtin@gmail.com" target="_blank">olivier.courtin@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Sun, Oct 14, 2012 at 1:46 AM, Andrea Peri <span dir="ltr"><<a href="mailto:aperi2007@gmail.com" target="_blank">aperi2007@gmail.com</a>></span> wrote:<br>
<div class="gmail_quote"><br></div><div class="gmail_quote">
Hi Andrea,</div><div class="gmail_quote"><div class="im"><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">reading the getcapabilities, I see the TinyOWS has not any LogicalOperator capability like AND , OR, etc..<br>
Is this correct for wfs 1.1.0 or is a lack of feature ?<br></blockquote><div><br></div></div><div>LogicalOperators are supported in TinyOWS,</div><div>and it appears it the capabilities as LogicalOperators tags.</div><div>
<br></div>
<div>Indeed you're right there's no detail on what is exactly supported at</div><div>capabilities level (indeed it means 'all'), </div><div>but it's related to OGC Filter XSD itself:</div><div><br></div>
<div>see schema/filter/1.1.0/filterCapabilities.xsd</div><div><br></div><div><br></div><div>Thanks for asking,</div><span class="HOEnZb"><font color="#888888"><div><br></div></font></span></div><span class="HOEnZb"><font color="#888888">-- <br>
Olivier<br>
</font></span><br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">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>
<br></blockquote></div><br><br clear="all"><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>qwerty àẹ̀́ù<br>-----------------<br><br>