<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style>
</head>
<body><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''</div>
<div><br></div>
<div>Seth</div>
<div><br></div>
<div id="sig62266145"><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>
<blockquote type="cite"><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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br></div>
<div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div>
</blockquote><div><br></div>
</body>
</html>