[mapserver-users] Problem with WMS time (filter do not works)

[Roberto Marzocchi]

Dear all,  i have done more test  if I uncomment the "wms_timedefault" "2018-01-01T00:00:00" line it give me the following error:  msWMSApplyTime: WMS server error. No Time value was given, and no default time value defined. otherwise it give me no error but my WMS use always the last line of the postgis table not considering the FILTER.  I try a lot of fiter syntaxes. my raster layer definition is the following:  # raster layer     LAYER      NAME "bui_20180101"      TYPE RASTER      STATUS ON      DEBUG ON      PROJECTION        "init=epsg:3003"      END      METADATA        "wms_title" "bui_20180101"        "wms_srs"   "EPSG:3003"        "wms_extent" "1436301.37500 4916704.50000 1701801.37500 5177704.50000"        "wms_timeextent" "2017-08-01/2100-12-31/PT24H"        "wms_timeitem" "day" #datetime is a column in postgis table of type timestamp        #"wms_timedefault" "2018-01-01T00:00:00"        "wms_enable_request" "*"        "ows_include_items"     "all"      END      OFFSITE 0 0 0      TILEITEM "location" #filepath is a column in postgis table with varchar of the filepath to each image      TILEINDEX "time_idx"      #FILTERITEM "day"      #FILTER "2018-01-01T00:00:00"      #FILTER (`[day]` = `2018-01-01T00:00:00`)      #FILTER ('[day]' = '2018-01-01T00:00:00')      FILTER ("day" = '2018-01-01T00:00:00')     END Thanks in advanced for your help.  R Eng. Roberto Marzocchi, PhD
GIS Project Coordinator
Gter srl (Unige spin-off)
Piazza De Marini 3/61 - 16123 Genova
P.IVA/CF 01998770992
ph: 010-8694830 - mob: 349-8786575
E-mail: roberto.marzocchi at gter.it
skype: roberto.marzocchi84
www.gter.it

--
Gter social
www.twitter.com/Gteronline - www.facebook.com/Gteronline - https://plus.google.com/+GterIt/posts 
www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis

-----------------------------------------------------------------
Please consider the environment before printing this email! ---- On mar, 21 ago 2018 13:26:23 +0200 Roberto Marzocchi <roberto.marzocchi at gter.it> wrote ---- Dear all,  I am following the guide to create WMS/WCS time [1]. (Mapserver 7.0.7 on Ubuntu Xenìal server) I created a PostGIS view with the following field: - id - location - day - geom I create a mapfile but when I create the layer the filter do not works (I see always the last row e.g the map of yesterday).  I try:       FILTERITEM "day"      FILTER "20180101" and  FILTER (`[day]` = `20180101`) like in the example      I try to change the day format in the PostGIS table from text to timestamp (e.g20180101 -->  2018-01-01 00:00:00) but nothing change.  There is something not clear to me.  R [1] - https://mapserver.org/ogc/wms_time.html#example-of-wms-t-with-postgis-tile-index-for-raster-imagery Eng. Roberto Marzocchi, PhD
GIS Project Coordinator
Gter srl (Unige spin-off)
Piazza De Marini 3/61 - 16123 Genova
P.IVA/CF 01998770992
ph: 010-8694830 - mob: 349-8786575
E-mail: roberto.marzocchi at gter.it
skype: roberto.marzocchi84
www.gter.it

--
Gter social
www.twitter.com/Gteronline - www.facebook.com/Gteronline - https://plus.google.com/+GterIt/posts 
www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis

-----------------------------------------------------------------
Please consider the environment before printing this email!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180824/ac167acf/attachment.htm>