kumy

Thanks for your answer, is `DATE()` an internal cortex keyword? I can't find it in Postgres doc https://www.postgresql.org/docs/9.1/functions-datetime.html

The best I can get is: ```php $filter = ['created_on_datetime > NOW() - cast(? as interval)', $year.' DAY']; ``` ```php $filter = ['created_on_datetime > DATE(NOW() - INTERVAL ?)', $year.' YEAR'];...

```php $filter = ["created_on_datetime > date_trunc('second', INTERVAL '? YEAR')", GK_SITE_NEWS_DISPLAY_DAYS_VALIDITY]; // PDOStatement: ERROR: invalid input syntax for type interval: "? YEAR" LINE 1: ...ated_on_datetime" > date_trunc('second', INTERVAL '? YEAR') ......

We missed the `now() - `in the last tests: ```php $filter = ["created_on_datetime > NOW() - date_trunc('second', INTERVAL '1 YEAR')"]; // Works, but not with '? YEAR' - seems related...

@ikkez thanks for yor help. We're getting quite close to something "usable"/"clean". This syntax **may** work with a little update to the library. ```php $filter = ["created_on_datetime > NOW() -...

Oh! I may simply follow the doc! I'll test that… > CORTEX.quoteConditions: Default TRUE. By default, all field names in where conditions are quoted automatically according to the used database...

An approach is to use `plpgsql` to create my own function: ```plpgsql CREATE OR REPLACE FUNCTION public.fresher_than( datetime timestamp with time zone, duration integer, unit character varying) RETURNS boolean LANGUAGE...

Nothing has changed on GK/GKM infra/worklows since a ling time. I just migrated to another server 2 or 3 month ago. Will however tests api on my side...

https://github.com/cgeo/cgeo/blob/ee97c24a38a1437572515230638975e02b613c3a/main/src/cgeo/geocaching/connector/trackable/GeokretyConnector.java#L234 c:geo is not using GKM to retrieve user inventory but GK directly. there is no caching on it. So I can't explain that part of "First test" > Your...

From what I see in my server logs, c:geo queries for GK only when opening a cache. It doesn't load GK again if you use the refresh button from the...