Greetings all, I'm trying to get a CQL filter working which can filter out data that's older than X amount from the present, for example, only return data from less than 5 days ago.
Following the docs regarding temporal predicates, I can get close: https://docs.geoserver.org/latest/en/user/filter/ecql_reference.html#temporal-predicate I would like to have something like, "time during P5D / PRESENT" where PRESENT is the current date and time. The closest I can find on this is a GIS stack exchange question where someone is trying to do similar, but on that post there's no true answer, as it's said that PRESENT is purely a WMS filter, not available in CQL: https://gis.stackexchange.com/questions/314882/wfs-how-to-do-relative-dates This seems to be true trying it out. If I put today's date in manually, it works exactly as I want it to. However, I want to do it based on the present without a need to adjust the CQL filter. Is there any way of accomplishing this? Or a close workaround? One idea I'm pondering is if the results can be returned in descending order by date, and just having a feature limit, but that may not have date precision, just a vague "recently", which may not be ideal. Cheers, Travis
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
