[mapserver-users] RE: 5.4 beta 3 - GetFeatureInfo /FILTER problems

[Jennifer Shanks]

Hello Everyone,

Gregor at HostGIS came to the rescue on this one.  He did some testing and suggested adding parenthesis to my filter statement.  So if I do the following my request returns the correct response:

FILTER "(access_cod = 'Restricted Access' or access_cod = 'Open Access')"

Thanks,
Jennifer



----- Forwarded Message ----
From: Jennifer Shanks <shanksje at yahoo.com>
To: mapserver-users at lists.osgeo.org
Sent: Thursday, March 12, 2009 1:55:07 PM
Subject: 5.4 beta 3 - GetFeatureInfo /FILTER problems

Hello,

We installed 5.4 beta 3 last night to take advantage of the new labeling options.  The new labels are great! 

I've noticed a problem with my GetFeatureInfo requests.  If there is a data FILTER on the layer, the request returns the wrong feature (always the same feature, no matter which location I select in CA.  If I comment out the FILTER, the request returns the correct result.  Below is an example of my layer.  

And a request looks like this:
http://www.parkinfo.org/cgi-bin/mapserv?map=wms_parkinfo_4326.map&SERVICE=WMS&SRS=EPSG:4326&VERSION=1.1.1&REQUEST=GetFeatureInfo&X=596&Y=636&QUERY_LAYERS=Parks_GetInfo&LAYERS=Parks_GetInfo&INFO_FORMAT=text/html&BBOX=-128.4521484375,36.13787471840729,-116.65283203124999,44.68427737181224&WIDTH=1060&HEIGHT=768&FORMAT=image/png&STYLES=

If I use this same request, I get different results depending on whether the filter is turned on or off.  

Any suggestions as to how I can fix this would be much appreciated.

Thanks,
Jennifer


LAYER
  NAME "Parks_GetInfo"
  STATUS OFF
  METADATA
    "wms_title" "Parks_GetInfo"
    "GROUP" "Polygon"
    "LAYER" "Parks_GetInfo"
  END #metadata
  TYPE POLYGON
  TEMPLATE "parkinfo_template.html"
  TRANSPARENCY 100
  CONNECTION "user=mapserver password=******* dbname=parkinfo_current host=localhost"
  CONNECTIONTYPE POSTGIS
  DATA "the_geom_gcs from statewide_osdb_notsvector as foo using unique gid using srid=4326"
  #FILTER "access_cod = 'Restricted Access' or access_cod = 'Open Access'"
  CLASS
    OUTLINECOLOR 255 0 0 
  END #class
  TOLERANCE 5
PROJECTION
"init=epsg:4326"
END
END # Layer