apex-learner
apex-learner

apex-learner

View Profile
  • 0
Contributor
Asked: 2021-09-18T13:47:12+05:30

how to add date facet in faceted search

  • 0

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,

 

apexfacetfaceted search

3 Answers

  1. Vinish Kapoor

    Vinish Kapoor

    View Profile
    Enlightened

    You need to get the date column as varchar2 and use the input field instead. For example:

    select ORDER_ID,
CUSTOMER_ID,
ORDER_TOTAL,
to_char(trunc(ORDER_TIMESTAMP), 'mm-dd-yyyy') od,
USER_NAME,
TAGS
from DEMO_ORDERS

    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.

    • 0
  2. apex-learner

    apex-learner

    View Profile
    Contributor

    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.

    • 0

You must login to add an answer.