<div dir="ltr">
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">Hi,<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif"><span> </span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">I have a dataset with a date field which I would like
to use as the field for the datetime parameter in an OGC API Feature service.
This field only contains dates, no time (e.g. 2002-06-01). I tried several
settings in the map-file but I did not manage to get data from the OGC API
Features service with a datetime, I keep getting the complete dataset, so it
looks like the parameter doesn’t do anything.<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif"><span> </span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">The swagger UI from Mapserver generates the following
url:<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif"><a href="http://localhost/cgi-bin/mapserv.exe/local-demo/ogcapi/collections/lake_abiyata/items?f=json&datetime=2002-06-01&offset=0&additionalProp1=%7B%7D&filter-lang=cql2-text&limit=10" style="color:rgb(70,120,134);text-decoration:underline">http://localhost/cgi-bin/mapserv.exe/local-demo/ogcapi/collections/lake_abiyata/items?f=json&datetime=2002-06-01&offset=0&additionalProp1=%7B%7D&filter-lang=cql2-text&limit=10</a><span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">And the result is 10 records instead of 1.<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif"><span> </span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">How do I have to set up a layer in my map file so it can output data
from my dataset with the datetime parameter and only get the records for the
given date or date range?<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><br></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">I have the following settings in my map-file:<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">"ows_timeextent"
"1940-01-01/2002-06-01"<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">"ows_timeitem" "datum"<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">"ows_timedefault" "1940-01-01"<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">"ows_timeformat" "YYYY-MM-DD"<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif"><span> </span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif">I also tried using oga_* instead of ows_* but this did
not help either.<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span lang="EN-US" style="font-size:9pt;font-family:"Verdana",sans-serif"><span> </span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span style="font-size:9pt;font-family:"Verdana",sans-serif">Thanks.<span></span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span style="font-size:9pt;font-family:"Verdana",sans-serif"><span> </span></span></p>
<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:"Aptos",sans-serif"><span style="font-size:9pt;font-family:"Verdana",sans-serif">Luuk<span></span></span></p>
<br></div>