<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style='font-size:10pt;font-family:Verdana,Arial,Helvetica,sans-serif;color:#00000;'><div>Thanks for your answer.. I try your suggestion using " instead of ' (otherwise I have a parsing error) but unfortunately no difference (the filter is "ignored"<br></div><div><br></div><div><br></div><div> PROCESSING "NATIVE_FILTER= 'day'='2018-01-01T00:00:00'"<br></div><div><br></div><div>R</div><div><br></div><div><pre class="moz-signature" cols="72"><span class="colour" style="color:rgb(153, 153, 153)">Eng. Roberto Marzocchi, PhD
GIS Project Coordinator
Gter srl (Unige spin-off)
Piazza De Marini 3/61 - 16123 Genova
</span><a href="http://P.IVA/CF" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)">P.IVA/CF</span></a><span class="colour" style="color:rgb(153, 153, 153)"> 01998770992
ph: 010-8694830 - mob: 349-8786575
E-mail: </span><a href="mailto:roberto.marzocchi@gter.it" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)">roberto.marzocchi@gter.it</span></a><span class="colour" style="color:rgb(153, 153, 153)">
skype: roberto.marzocchi84
</span><a href="http://www.gter.it" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)">www.gter.it</span></a><span class="colour" style="color:rgb(153, 153, 153)">
--
Gter social
</span><a href="http://www.twitter.com/Gteronline" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)">www.twitter.com/Gteronline</span></a><span class="colour" style="color:rgb(153, 153, 153)"> - </span><a href="http://www.facebook.com/Gteronline" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)">www.facebook.com/Gteronline</span></a><span class="colour" style="color:rgb(153, 153, 153)"> - </span><a href="https://plus.google.com/+GterIt/posts" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)">https://plus.google.com/+GterIt/posts</span></a><span class="colour" style="color:rgb(153, 153, 153)">
</span><a href="http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)">www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis</span></a><span class="colour" style="color:rgb(153, 153, 153)">
-----------------------------------------------------------------
Please consider the environment before printing this email! </span><span class="colour" style="color:rgb(153, 153, 153)"></span><br></pre><div><span class="colour" style="color:rgb(153, 153, 153)"></span><br></div></div><div><br></div><div class="zmail_extra"><div><div><br></div><div>---- On ven, 24 ago 2018 14:37:00 +0200 <b>Seth G <sethg@geographika.co.uk></b> wrote ----<br></div></div><div><br></div><blockquote style="border-left: 1px solid #cccccc; padding-left: 6px; margin:0 0 0 5px"><div><div>Hi,<br></div><div><br></div><div>Is there any difference if you use a native filter? E.g. <br></div><div><br></div><div>PROCESSING 'NATIVE_FILTER=day= '2018-01-01T00:00:00''<br></div><div><br></div><div>Seth<br></div><div><br></div><div><div class="signature">--<br></div><div class="signature">web:http://geographika.co.uk<br></div><div class="signature">twitter: @geographika<br></div></div><div><br></div><div><br></div><div>On Fri, Aug 24, 2018, at 2:14 PM, Roberto Marzocchi wrote:<br></div><div><br></div><div><br></div></div><blockquote><div style="font-size: 10pt; font-family: Verdana, Arial, Helvetica, sans-serif"><div>Dear all, <br></div><div><br></div><div>i have done more test <br></div><div><br></div><div>if I uncomment the "wms_timedefault" "2018-01-01T00:00:00" line it give me the following error: <br></div><div><br></div><div><i>msWMSApplyTime: WMS server error. No Time value was given, and no default time value defined.</i><br></div><div><br></div><div>otherwise it give me no error but my WMS use always the last line of the postgis table not considering the FILTER. <br></div><div><br></div><div>I try a lot of fiter syntaxes.<br></div><div><br></div><div><br></div><div>my raster layer definition is the following: <br></div><div><br></div><div># raster layer<br></div><div> LAYER<br></div><div> NAME "bui_20180101"<br></div><div> TYPE RASTER<br></div><div> STATUS ON<br></div><div> DEBUG ON<br></div><div> PROJECTION<br></div><div> "init=epsg:3003"<br></div><div> END<br></div><div> METADATA<br></div><div> "wms_title" "bui_20180101"<br></div><div> "wms_srs" "EPSG:3003"<br></div><div> "wms_extent" "1436301.37500 4916704.50000 1701801.37500 5177704.50000"<br></div><div> "wms_timeextent" "2017-08-01/2100-12-31/PT24H"<br></div><div> "wms_timeitem" "day" #datetime is a column in postgis table of type timestamp<br></div><div> #"wms_timedefault" "2018-01-01T00:00:00"<br></div><div> "wms_enable_request" "*"<br></div><div> "ows_include_items" "all"<br></div><div> END<br></div><div> OFFSITE 0 0 0<br></div><div> TILEITEM "location" #filepath is a column in postgis table with varchar of the filepath to each image<br></div><div> TILEINDEX "time_idx"<br></div><div> #FILTERITEM "day"<br></div><div> #FILTER "2018-01-01T00:00:00"<br></div><div> #FILTER (`[day]` = `2018-01-01T00:00:00`)<br></div><div> #FILTER ('[day]' = '2018-01-01T00:00:00')<br></div><div> FILTER ("day" = '2018-01-01T00:00:00')<br></div><div> END<br></div><div><br></div><div><br></div><div>Thanks in advanced for your help. <br></div><div><br></div><div>R<br></div><div><br></div><div><pre><span class="colour" style="color:rgb(153, 153, 153)">Eng. Roberto Marzocchi, PhD
GIS Project Coordinator
Gter srl (Unige spin-off)
Piazza De Marini 3/61 - 16123 Genova
</span><a target="_blank" href="http://P.IVA/CF"><span class="colour" style="color:rgb(153, 153, 153)">P.IVA/CF</span></a><span class="colour" style="color:rgb(153, 153, 153)"> 01998770992
ph: 010-8694830 - mob: 349-8786575
E-mail: </span><a target="_blank" href="mailto:roberto.marzocchi@gter.it"><span class="colour" style="color:rgb(153, 153, 153)">roberto.marzocchi@gter.it</span></a><span class="colour" style="color:rgb(153, 153, 153)">
skype: roberto.marzocchi84
</span><a target="_blank" href="http://www.gter.it"><span class="colour" style="color:rgb(153, 153, 153)">www.gter.it</span></a><span class="colour" style="color:rgb(153, 153, 153)">
--
Gter social
</span><a target="_blank" href="http://www.twitter.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)">www.twitter.com/Gteronline</span></a><span class="colour" style="color:rgb(153, 153, 153)"> - </span><a target="_blank" href="http://www.facebook.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)">www.facebook.com/Gteronline</span></a><span class="colour" style="color:rgb(153, 153, 153)"> - </span><a target="_blank" href="https://plus.google.com/+GterIt/posts"><span class="colour" style="color:rgb(153, 153, 153)">https://plus.google.com/+GterIt/posts</span></a><span class="colour" style="color:rgb(153, 153, 153)">
</span><a target="_blank" href="http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis"><span class="colour" style="color:rgb(153, 153, 153)">www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis</span></a><span class="colour" style="color:rgb(153, 153, 153)">
-----------------------------------------------------------------
Please consider the environment before printing this email! </span><span class="colour" style="color:rgb(153, 153, 153)"></span><br></pre><div><span class="colour" style="color:rgb(153, 153, 153)"></span><br></div></div><div><br></div><div><div><div><br></div><div>---- On mar, 21 ago 2018 13:26:23 +0200 <b>Roberto Marzocchi <roberto.marzocchi@gter.it></b> wrote ----<br></div></div><div><br></div><blockquote style="border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 6px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 5px"><div><div style="font-size: 10pt; font-family: Verdana, Arial, Helvetica, sans-serif"><div>Dear all, <br></div><div><br></div><div>I am following the guide to create WMS/WCS time [1]. (Mapserver 7.0.7 on Ubuntu Xenìal server)<br></div><div><br></div><div>I created a PostGIS view with the following field:<br></div><div>- id<br></div><div>- location<br></div><div>- day<br></div><div>- geom<br></div><div><br></div><div>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). <br></div><div><br></div><div>I try: <br></div><div> FILTERITEM "day"<br></div><div> FILTER "20180101"<br></div><div><br></div><div>and <br></div><div><br></div><div>FILTER (`[day]` = `20180101`)<br></div><div><br></div><div>like in the example<br></div><div> <br></div><div><br></div><div>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. <br></div><div><br></div><div><br></div><div>There is something not clear to me. <br></div><div><br></div><div>R<br></div><div><br></div><div>[1] - <a target="_blank" href="https://mapserver.org/ogc/wms_time.html#example-of-wms-t-with-postgis-tile-index-for-raster-imagery">https://mapserver.org/ogc/wms_time.html#example-of-wms-t-with-postgis-tile-index-for-raster-imagery</a><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><pre><span class="colour" style="color:rgb(153, 153, 153)">Eng. Roberto Marzocchi, PhD
GIS Project Coordinator
Gter srl (Unige spin-off)
Piazza De Marini 3/61 - 16123 Genova
</span><a target="_blank" href="http://P.IVA/CF"><span class="colour" style="color:rgb(153, 153, 153)">P.IVA/CF</span></a><span class="colour" style="color:rgb(153, 153, 153)"> 01998770992
ph: 010-8694830 - mob: 349-8786575
E-mail: </span><a target="_blank" href="mailto:roberto.marzocchi@gter.it"><span class="colour" style="color:rgb(153, 153, 153)">roberto.marzocchi@gter.it</span></a><span class="colour" style="color:rgb(153, 153, 153)">
skype: roberto.marzocchi84
</span><a target="_blank" href="http://www.gter.it"><span class="colour" style="color:rgb(153, 153, 153)">www.gter.it</span></a><span class="colour" style="color:rgb(153, 153, 153)">
--
Gter social
</span><a target="_blank" href="http://www.twitter.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)">www.twitter.com/Gteronline</span></a><span class="colour" style="color:rgb(153, 153, 153)"> - </span><a target="_blank" href="http://www.facebook.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)">www.facebook.com/Gteronline</span></a><span class="colour" style="color:rgb(153, 153, 153)"> - </span><a target="_blank" href="https://plus.google.com/+GterIt/posts"><span class="colour" style="color:rgb(153, 153, 153)">https://plus.google.com/+GterIt/posts</span></a><span class="colour" style="color:rgb(153, 153, 153)">
</span><a target="_blank" href="http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis"><span class="colour" style="color:rgb(153, 153, 153)">www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis</span></a><span class="colour" style="color:rgb(153, 153, 153)">
-----------------------------------------------------------------
Please consider the environment before printing this email! </span><span class="colour" style="color:rgb(153, 153, 153)"></span><br></pre><div><span class="colour" style="color:rgb(153, 153, 153)"></span><br></div></div><div><br></div></div></div></blockquote></div><div><br></div></div><div><br></div><div><u>_______________________________________________</u><br></div><div>mapserver-users mailing list<br></div><div><a target="_blank" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br></div><div><a target="_blank" href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div></blockquote></blockquote></div><style>p.MsoNormal, p.MsoNoSpacing {
margin: 0
}<br></style><div><br></div></div><br></body></html>