[mapserver-users] TinyOWS and the logical operators

[Olivier Courtin]

On Sun, Oct 14, 2012 at 12:04 PM, Andrea Peri <aperi2007 at gmail.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20121014/245b1003/attachment-0001.html>