Unexpected WFS GetFeature results

[Yewondwossen Assefa]

Tom,

  I did make some changes recently to the way filters were handled for
postgis layers (Bug http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1292).

  It's probably related to thoses changes. Is it easy for you to test it
against 4.4.x releases ? If you can test and It works I will start
looking into the code to see what the problem is.

Later,


Kralidis,Tom [Burlington] wrote:
> Hi,
>
> (MapServer CVS, FC2, latest stable supporting libs).
>
> I have a WFS instance running against a PostGIS table, and when I invoke
> a Filter'd GetFeature operation (bbox AND a nested OR), I expect one
> result to be returned (only one record in the DB satisfies this
> request).
>
> I've attached a sample HTML form page to correctly invoke the request.
>
> However, I receive all records back in the DB.
>
> Any idea what's going on here?  FYI, here's my DATA string in the LAYER
> object:
>
>   DATA "the_geom from (select service_endpoints.organization as
> organization,service_endpoints.endpoint_getresource as
> endpoint_getresource,service_endpoints.service_type as
> service_type,service_endpoints.service_version as
> service_version,service_resources.the_geom as
> the_geom,service_resources.resource_id as
> resource_id,service_resources.service_id as
> service_id,service_resources.name as name,service_resources.title as
> title,service_resources.abstract as abstract,service_resources.keywords
> as keywords,service_resources.dataurl as
> dataurl,service_resources.metadataurl as
> metadataurl,service_resources.legendurl as
> legendurl,service_resources.scale_min as
> scale_min,service_resources.scale_max
>  as scale_max,service_resources.srs as srs,service_endpoints.format_list
> as format_list,service_resources.style_list as
> style_list,service_resources.time_extent as
> time_extent,service_resources.queryable as queryable from
> service_resources inner join service_endpoints on
> service_endpoints.service_id = service_resources.service_id) as t using
> unique resource_id"
>
> Thanks
>
> ..Tom
>
>
> ------------------------------------------------------------------------
>
>
>
>
>
>

--
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst

Email: assefa at dmsolutions.ca
http://www.dmsolutions.ca/

Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925
----------------------------------------------------------------