Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic Date Range in Faceted Search

Andreas KuchlerJul 21 2022 — edited Jul 21 2022

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
image.pngI'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.
image.png

When I'm creating static values with the same output of the query it works
image.png
Do anyone know what I did wrong?

regards

Andreas

This post has been answered by Andreas Kuchler on Jul 21 2022
Jump to Answer
Comments
Post Details
Added on Jul 21 2022
4 comments
1,808 views