Hi all,
I use Faceted Search and want to create a facet with a range with a date format.
I need the following criteria:
Range1: Today.
Range2: Today + 10 days
Range3: Today + 30 days
I use the following query in the list of values
select 'today' as d, (to_char(sysdate,'YYYYMMDD')||'000000|'||to_char(sysdate,'YYYYMMDD')||'235959') as r from dual
union
select 'today + 10' as d, (to_char(sysdate,'YYYYMMDD')||'000001|'||to_char(sysdate+10,'YYYYMMDD')||'000000') as r from dual
union
select 'today + 30' as d, (to_char(sysdate,'YYYYMMDD')||'000001|'||to_char(sysdate+30,'YYYYMMDD')||'000000') as r from dual
order by 1 asc;
Apparently, the ranges must not overlap - is there a solution here?
Regards
Andreas