[mapserver-users] TinyOWS and the logical operators

[Andrea Peri]

Hi Olivier,

I resolved it.

The "and" operator is named using the first letter uppercase.

So  <And> is recognized, meanwhile <AND> was not recognized.
I guest perhaps there is some bugs, but not really sure.

However this version of the request work and has the right result.

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=<Filter
xmlns:wfs="http://www.opengis.net/wfs
"><And><PropertyIsEqualTo><PropertyName>comune</PropertyName><Literal>FIRENZE</Literal></PropertyIsEqualTo><PropertyIsEqualTo><PropertyName>tipo_prop</PropertyName><Literal>Comune</Literal></PropertyIsEqualTo></And></Filter>

Many thx,


2012/10/14 Olivier Courtin <olivier.courtin at gmail.com>

> 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
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>


-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20121014/65caf319/attachment.html>