Hi,
i want to use a dynamic range of dates in a faceted search.
I have a date column field with daily entries.
The range should be like this.
last week
last month
last year
I know that date format is supported within faceted search. I can't use a static range like this
I'm using this query as LOV (SQL Query):
select 'last week' as d, ('|'||to_char(sysdate-7,'YYYYMMDDHH24MISS')) as r from dual
union
select 'last month' as d, ('|'||to_char(sysdate-30,'YYYYMMDDHH24MISS')) as r from dual
union
select 'last year' as d, ('|'||to_char(sysdate-365,'YYYYMMDDHH24MISS')) as r from dual;
When I do it like that I got the faceted displayed but greyed out. There are definitely date entries in the column within the given range.

When I'm creating static values with the same output of the query it works

Do anyone know what I did wrong?
regards
Andreas