On Sun, Oct 14, 2012 at 12:04 PM, Andrea Peri <[email protected]> wrote:
Andrea, If the AND operator is supported from TinyOWS, this mean that I'm wrong > something else. > > Any hint is welcome > If i check with WFS 1.1 CITE: $ sudo make install-test110 There 3 tests related to And Logical Operator with GetFeature -> 0210 to 0212: So take one: $ test/unit_test test/wfs_110/cite/0211 4 Input query: <?xml version="1.0" encoding="UTF-8"?><wfs:GetFeature xmlns:wfs=" http://www.opengis.net/wfs"; xmlns:ogc="http://www.opengis.net/ogc"; xmlns:p=" http://teamengine.sourceforge.net/parsers"; xmlns:xi=" http://www.w3.org/2001/XInclude"; xmlns:saxon="http://saxon.sf.net/"; xmlns:xlink="http://www.w3.org/1999/xlink"; xmlns=" http://www.occamlab.com/ctl"; xmlns:xs="http://www.w3.org/2001/XMLSchema"; xmlns:ows="http://www.opengis.net/ows"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"; xmlns:xsd=" http://www.w3.org/2001/XMLSchema"; xmlns:ctl="http://www.occamlab.com/ctl"; xmlns:sf="http://cite.opengeospatial.org/gmlsf"; xmlns:tec="java:com.occamlab.te.TECore" xmlns:te="http://www.occamlab.com/te"; xmlns:parsers="http://www.occamlab.com/te/parsers"; xmlns:gml=" http://www.opengis.net/gml"; xmlns:myparsers=" http://teamengine.sourceforge.net/parsers"; 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> SQL Request produced: 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')) I didn't look in detail to you query for now, let me know it this sample is enough to you (or not), -- Olivier
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
