WFS Filter

[Yewondwossen Assefa]

The way things work is that the filter encoding  is transformed into 
something suitable for each layer and the layer's filter element is set 
with it :
  * For shape file, It will be a normal mapserver expression,
  * for postgis, oracle and ogr, it will be transformed into an sql 
expression. For OGR It should result into something like WHERE 
(Item_name='Item_Value')

  Bug http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1292 has more 
details on this.

  What you could try is to set manually a valid sql expression on you 
layer's filter and see if that works.

Later,

Sture Dingsøyr wrote:
> Hi all
> 
> Been doing some testing with Mapserver WFS and FILTER.
> 
> When the Mapserver layer is getting its data from e.g. SHAPE, POSTGRESQL the WFS FILTER functions seem to work fine.  I can filter data by using both BBOX or e.g. a PropertyIsLike query. 
> 
> But...i was now testing the FILTER functions on a layer where the data is from a MS SQL server (point layer). I am fetching my data via OGR. Mapserver renders the layer just fine, i can use WFS BBOX FILTER, but when i try a WMS FILTER using e.g. WFS  PropertyIsLike query, Mapserver returns all records in the layer. Nothing gets filtered...
> 
> Should not Mapserver (via WFS) filter data in the same way regardless of how the data is fetched...that is e.g. via SHAPE, POSTGRESQL, OGR etc
> 
> Regards 
> Sture


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

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

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