Hi, What does not work for you in the WMS-T support as documented in WMS Time - MapServer 8.0.2 documentation<https://mapserver.org/ogc/wms_time.html>?
-Jukka Rahkonen- Lähettäjä: MapServer-users <[email protected]> Puolesta Marcin Niemyjski via MapServer-users Lähetetty: torstai 20. kesäkuuta 2024 13.49 Vastaanottaja: Marcin Niemyjski via MapServer-users <[email protected]> Aihe: [MapServer-users] TIME dimension as runtime substitution within DATA query? Hello Is it possible to use the TIME dimension as a parameter for runtime substitution? What I'm trying to achieve: I want to limit the rows in the database query by applying a date within the query itself. Specifically, I need to use the TIME dimension instead of custom parameters like start_date and stop_date to ensure full compatibility with the OGC WMS-T standard. There is also the issue of parsing the TIME value into a format acceptable by the query. However, for now, let's assume that I'm providing a single date within TIME. LAYER DEBUG 5 STATUS OFF NAME "stac_query" TYPE POLYGON CONNECTIONTYPE postgis CONNECTION "***" DATA "geometry from ... WHERE datetime >= %TIME% AND datetime <%TIME% AND (id = ANY ('{%pid%}') or '%pid%' = '-1' AND collection = ANY ('{cryo-demo}') ) ORDER BY datetime DESC, id DESC) as subquerry using unique id using srid=4326" PROJECTION "init=epsg:4326" END VALIDATION 'pid' '^.{2,37}$' 'asset' '^.{3,6}$' 'default_pid' '-1' 'default_asset' '-1' END METADATA "wms_srs" "EPSG:3857 EPSG:4326 EPSG:2180" "wms_title" "stac_query" "wms_timeextent" "2015-01-01/2025-01-01/P1D" "wms_timeitem" "datetime" "wms_timedefault" "2024-04-08" "wms_enable_request" "!*" END PROCESSING "CLOSE_CONNECTION=DEFER" END Any clue? Best, Marcin
_______________________________________________ MapServer-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
