Thanks Andrea and Jody, This helped me a lot!
As I am not on my phone, and for other ogc api users, this is the correct syntax: &filter-lang=cql-text Bart Van: Andrea Aime <andrea.a...@geosolutionsgroup.com> Verzonden: zaterdag 2 maart 2024 18:25 Aan: Jody Garnett <jody.garn...@gmail.com> CC: Verbeeck Bart (AIV) <bart.verbe...@vlaanderen.be>; geoserver-users <geoserver-users@lists.sourceforge.net> Onderwerp: Re: [Geoserver-users] ogc api features filter: during I'm just guessing here (answering from phone), but if memory serves me right, the default filter language changed from ECQL to CQL2 (following the evolution of the standard), with an implementation that's also not up to date (CQL2 keeps on changing). Try using filter-lang to choose ECQL instead? Ah, found the syntax for CQL2, something like this (found it in tests for our current implementation): T_DURING(ATTR1, INTERVAL(TIMESTAMP('2006-11-30T01:30:00Z'), TIMESTAMP('2006-12-31T01:30:00Z'))) However, it seems the CQL2 syntax evolved in the meantime, and the function in the latest version can only be used to compare an interval with another interval, and not any longer an instant with an interval. Check the standard DRAFT here: https://docs.ogc.org/DRAFTS/21-065.html Long story short, if you want something that is stable interface wise, at least for the time being, add "&filter-lang=ecql-tex" to your request and keep on using GeoServer's own CQL flavor. Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://bit.ly/gs-services-us for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions Group phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 https://www.geosolutionsgroup.com/ http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail On Sat, Mar 2, 2024 at 9:35 AM Jody Garnett <jody.garn...@gmail.com<mailto:jody.garn...@gmail.com>> wrote: Verbeeck, The best way to assist with this project is to pitch in and help during an ogc / osgeo code sprint. Or to interact with the developer Andrea who is seeking funding to work on this module. It is really nice that you are testing, since the specification is a moving target I am not surprised if some functionality changes between 2.19 and 2.24 (which is quite a long time for a community module). I also would love to see this module improved, but do not know how to get it funded (or myself time to work on it). -- Jody Garnett On Mar 1, 2024 at 6:33:40 AM, Verbeeck Bart (AIV) via Geoserver-users <geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>> wrote: Dear all The question below appears to be under LDAP snow. Meanwhile I found another time related issue in 2.19 time can be between single quotes (but doesn’t have to geo.api.vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart < %272024-02-28T09:19:48.330Z%27<https://geo.api.vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart%20%3C%20%272024-02-28T09:19:48.330Z%27> geo.api.vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart < 2024-02-28T09:19:48.330Z<https://geo.api.vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart%20%3C%202024-02-28T09:19:48.330Z> in 2.24 it has to be between single quotes geo.api.beta-vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart < %272024-02-28T09:19:48.330Z%27<https://geo.api.beta-vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart%20%3C%20%272024-02-28T09:19:48.330Z%27> geo.api.beta-vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart < 2024-02-28T09:19:48.330Z<https://geo.api.beta-vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart%20%3C%202024-02-28T09:19:48.330Z> (gives error) same question: Is this a definitive change or a bug? Bart Van: Verbeeck Bart (AIV) via Geoserver-users <geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>> Verzonden: woensdag 28 februari 2024 11:43 Aan: geoserver-users <geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>> Onderwerp: [Geoserver-users] ogc api features filter: during Hello Concerning versions 2.19 -> 2.24, ogc api features It appears that version 2.24 doesnot (2.19 did) support the time filter keyword “during”. Is this a definitive change or a bug? 2.19 geo.api.vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart during 2024-02-28T09:19:48.330Z/2024-03-29T22:59:59.999Z<https://geo.api.vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart%20during%202024-02-28T09:19:48.330Z/2024-03-29T22:59:59.999Z> 2.24 geo.api.beta-vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart during 2024-02-28T09:19:48.330Z/2024-03-29T22:59:59.999Z<https://geo.api.beta-vlaanderen.be/GIPOD/ogc/features/collections/HINDERGEVOLG/items?f=application/json&startIndex=0&crs=EPSG:31370&limit=20&filter=HindranceStart%20during%202024-02-28T09:19:48.330Z/2024-03-29T22:59:59.999Z> Bart _______________________________________________ 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<mailto:Geoserver-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/geoserver-users _______________________________________________ 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<mailto:Geoserver-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/geoserver-users
_______________________________________________ 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