Opened 13 years ago

Last modified 13 years ago

#3795 new defect

WMS Layer Filter ignored when using TIME Parameters (SQL Server 2008 Driver)

Reported by: geographika Owned by: hobu
Priority: normal Milestone:
Component: Input - Native MS SQL Server Support Version: 5.6
Severity: normal Keywords: mssql wms filter time
Cc: tamas

Description

When MapServer WMS layer from OpenLayers with a time paramter such as TIME=2005%2F2020 the layer's filter is ignored in the SQL statement run against SQL Server 2008.

My WMS layer in the MapFile has the following parameters:

DATA "GEOM from table USING UNIQUE FID USING SRID=29902" FILTER "MyVal = 2"

I'm using MapServer 5.6 and the MS SQL 2008 data plugin.

It looks as though this may also have been an issue with PostGIS in the past.

Change History (3)

comment:1 by geographika, 13 years ago

Link to the PostGIS issue fix - http://trac.osgeo.org/mapserver/changeset/6412

comment:2 by sdlime, 13 years ago

Component: MapServer C LibraryInput - Native MS SQL Server Support
Owner: changed from sdlime to hobu

Moving to MS SQL Server component... Steve

comment:3 by sdlime, 13 years ago

Cc: tamas added
Note: See TracTickets for help on using tickets.