Ticket #3795 (new defect)

Opened 2 years ago

Last modified 2 years ago

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

Changed 2 years ago by geographika

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

Changed 2 years ago by sdlime

  • owner changed from sdlime to hobu
  • component changed from MapServer C Library to Input - Native MS SQL Server Support

Moving to MS SQL Server component... Steve

Changed 2 years ago by sdlime

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