<!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;'><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</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). </div><div><br></div><div>I try: </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</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</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 id=""><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><br></body></html>