Filtering by date field not working on 2.1.4

1

Since 2.1.4, I’m unable to filter on a date field on an aggregated reflection whose a field is a date field.
The filter criterium is basic, date_field >= ‘2018-01-01’
I get an Invalid Query error. I tried many tricks (casting to date, etc…) without success.

Here is the query profile :
7fc75e23-fe28-4b9f-be49-4946d75f6e7d.zip (642.2 KB)

2

Can you go to Admin > Advanced Settings and set the following support key planner.experimental.pclean_logical to false?

1 Like
3

Thanks Laurent.
That indeed works very well, after having set planner.experimental.pclean_logical to false.