On Sun, Oct 14, 2012 at 12:04 PM, 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>Andrea,<br><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
If the AND operator is supported from TinyOWS, this mean that I'm wrong something else.<br><br>Any hint is welcome<br></blockquote><div><br></div><div>If i check with WFS 1.1 CITE:</div><div>$ sudo make install-test110</div>
<div><br></div><div>There 3 tests related to And Logical Operator with GetFeature -> 0210 to 0212:</div><div>So take one:</div><div>$ test/unit_test test/wfs_110/cite/0211 4</div><div><br></div><div>Input query:</div><div>
<?xml version="1.0" encoding="UTF-8"?><wfs:GetFeature xmlns:wfs="<a href="http://www.opengis.net/wfs">http://www.opengis.net/wfs</a>" xmlns:ogc="<a href="http://www.opengis.net/ogc">http://www.opengis.net/ogc</a>" xmlns:p="<a href="http://teamengine.sourceforge.net/parsers">http://teamengine.sourceforge.net/parsers</a>" xmlns:xi="<a href="http://www.w3.org/2001/XInclude">http://www.w3.org/2001/XInclude</a>" xmlns:saxon="<a href="http://saxon.sf.net/">http://saxon.sf.net/</a>" xmlns:xlink="<a href="http://www.w3.org/1999/xlink">http://www.w3.org/1999/xlink</a>" xmlns="<a href="http://www.occamlab.com/ctl">http://www.occamlab.com/ctl</a>" xmlns:xs="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:ows="<a href="http://www.opengis.net/ows">http://www.opengis.net/ows</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:ctl="<a href="http://www.occamlab.com/ctl">http://www.occamlab.com/ctl</a>" xmlns:sf="<a href="http://cite.opengeospatial.org/gmlsf">http://cite.opengeospatial.org/gmlsf</a>" xmlns:tec="java:com.occamlab.te.TECore" xmlns:te="<a href="http://www.occamlab.com/te">http://www.occamlab.com/te</a>" xmlns:parsers="<a href="http://www.occamlab.com/te/parsers">http://www.occamlab.com/te/parsers</a>" xmlns:gml="<a href="http://www.opengis.net/gml">http://www.opengis.net/gml</a>" xmlns:myparsers="<a href="http://teamengine.sourceforge.net/parsers">http://teamengine.sourceforge.net/parsers</a>" version="1.1.0" service="WFS"><wfs:Query typeName="sf:AggregateGeoFeature"><ogc:Filter><ogc:And><ogc:PropertyIsGreaterThanOrEqualTo><ogc:PropertyName>sf:doubleProperty</ogc:PropertyName><ogc:Literal>24510</ogc:Literal></ogc:PropertyIsGreaterThanOrEqualTo><ogc:PropertyIsEqualTo matchCase="false"><ogc:PropertyName>sf:featureCode</ogc:PropertyName><ogc:Literal>ak020</ogc:Literal></ogc:PropertyIsEqualTo></ogc:And></ogc:Filter></wfs:Query></wfs:GetFeature></div>
<div><br></div><div><br></div><div>SQL Request produced:</div><div>SELECT "description","name",ST_AsGML(3, ST_Transform("multiPointProperty"::geometry,4326),6, 23) AS "multiPointProperty" ,ST_AsGML(3, ST_Transform("multiCurveProperty"::geometry,4326),6, 23) AS "multiCurveProperty" ,ST_AsGML(3, ST_Transform("multiSurfaceProperty"::geometry,4326),6, 23) AS "multiSurfaceProperty" ,"doubleProperty","intRangeProperty","strProperty","featureCode","id" FROM public."AggregateGeoFeature" WHERE ("doubleProperty" >= 24510 AND lower("featureCode") = lower('ak020'))</div>
<div><br></div><div><br></div><div>I didn't look in detail to you query for now,</div><div>let me know it this sample is enough to you (or not),</div><div><br></div></div>-- <br>Olivier<br>