How to use Date in Hybris Flexible Search Query?

java hybris
AppleBud picture AppleBud · Apr 18, 2017 · Viewed 15.7k times · Source

I am trying to fetch records from hybris using Flexible Search query based on date. I tried to find some resources for the same but none worked out.

Basically, I am trying to find products where modified date is equals to the current date.

My current query is:

Select * from {product as p} where to_char({p.modifiedDate},'dd/mm/yyyy')==to_char('18/04/2017','dd/mm/yyyy')

This is my current query. However, when I run this using HAC, it give me error:

xception message: ORA-00936: missing expression
Exception stacktrace:
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776) oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)

Can anyone help me out on this ?

Answer

onetuser picture onetuser · Apr 18, 2017

As alain.janinm said

  1. modifiedtime instead of modifiedDate

  2. = instead of ==

  3. I guess you do not need the second to_char because it is already char.

Here is official documentation with Oracle and MySQL examples:

Related questions

Hybris Entity not found exception

We have a rather major issue in our hybris implementation with missing data base entires. We have been getting "Entity Not Found" errors. It started rather randomly on last Monday. The records that are causing errors are in the database …

Read More
HYBRIS - How components and slots work in JSP file?

Recently I am working with Hybris, and I can not understand how the components work. I know how to create and define one, how to add them to the page I want, etc. But I do not understand how to …

Read More
Creating product data model on Hybris e-commerce

I'm evaluating different e-commerce platforms. As part of this work I'm evaluating how our present product structure fits the platforms. With vendors such as IBM it's easy since they have all the material publicly on web. I have growing interest …

Read More