Hi There,
There is ticket on this issue :
http://trac.osgeo.org/mapserver/ticket/2388.
I have committed the fix in cvs. If you have a chance, please give it
a try and update the bug.
Best Regards
Jørn Vegard Røsnes wrote:
Hi all,
I'm running Mapserver v5.1-dev.
Postgresql is running with debug level 5.
When I send a request containing result and time filtering, it seems that only
the result filtering is included in the generated SQL WHERE statement (from
Postgresql log). The eventtime filtering seems to be omitted.
URL (partly):
eventtime=<gml:TimePeriod><gml:beginPosition>2007-11-05T08:00:00Z</gml:beginPosition><gml:endPosition>2007-11-05T08:30:00Z</gml:endPosition></gml:TimePeriod>&
result=<Filter><ogc:PropertyIsEqualTo><ogc:PropertyName>mmsi_nb</ogc:PropertyName><ogc:Literal>258069000</ogc:Literal></ogc:PropertyIsEqualTo></Filter>
If I include only the eventtime in the SOS request, the SQL WHERE statement
contains the time filtering.
URL (partly):
eventtime=<gml:TimePeriod><gml:beginPosition>2007-11-05T08:00:00Z</gml:beginPosition><gml:endPosition>2007-11-05T08:30:00Z</gml:endPosition></gml:TimePeriod>
Any ideas are appreciated.
I can send more details off-list.
cheers
Jørn Vegard
--
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst
Email: [EMAIL PROTECTED]
http://www.dmsolutions.ca/
Phone: (613) 565-5056 (ext 14)
Fax: (613) 565-0925
----------------------------------------------------------------