Sign Up

❇️ 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.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions
apex-learner
apex-learner

apex-learner

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
apex-learnerContributor
Asked: September 18, 20212021-09-18T13:47:12+05:30 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
  • 1k
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer

3 Answers

  1. Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    2021-09-18T14:04:37+05:30Added an answer on September 18, 2021 at 2:04 pm

    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
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • apex-learner

      apex-learner

      • 1 Question
      • 2 Answers
      • 0 Best Answers
      • 25 Points
      View Profile
      apex-learner Contributor
      2021-09-18T14:17:15+05:30Replied to answer on September 18, 2021 at 2:17 pm

      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?

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
  2. apex-learner

    apex-learner

    • 1 Question
    • 2 Answers
    • 0 Best Answers
    • 25 Points
    View Profile
    apex-learner Contributor
    2021-09-18T14:49:16+05:30Added an answer on September 18, 2021 at 2:49 pm

    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
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

You must login to add an answer.

Forgot Password?

Sidebar

Explore

  • Ask Question
  • Add Post

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us