Hi.
How can I include DATE RANGE search criteria in Faceted Search?
(while I was trying, I am getting the following error.
Facet is not supported for DATE or TIMESTAMP columns.)
Thanks,
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Vinish Kapoor
You need to get the date column as varchar2 and use the input field instead. For example:
Now for the OD column, use the input field and for the database column property, specify the OD column. Then you would be able to enter a date using the same format specified in the SQL query to filter the result at runtime.
apex-learner
Thank you very much for your quick response, and it works :).
Unfortunately, I have some more queries.
I want to put the date range (from_date and to_date as date picker) and filter according to the date range selected.
(select PROJECT,TASK_NAME,
to_char(trunc(START_DATE), 'mm-dd-yyyy') od,
to_char(trunc(END_DATE), 'mm-dd-yyyy') ed
from EBA_DEMO_IR_PROJECTS)
So could you please advise me on how I can achieve it, please?
apex-learner
I think to make two facets input fields (the first one with greater than and the second less than). How can I group it and use a date picker or date picker range as an input type? Would you please let me know if there is a more effective method?
Thank you very much.