Hi,
I am getting "SQL search error : incompatible data type" while searching with enum data type in simple search.
how to add enum data type and other data types [date] in configuration file , for simple search.
I have tried by adding enum data type as mentioned below, It is not working. I got "SQL search error : incompatible data" Error, while searching.
Ex:
<yss:simple-search xmlns:yss="http://www.hybris.com/cockpitng/config/simplesearch">
<yss:field name="code"/>
<yss:field name="name"/>
<yss:field name="remarks"/>
<yss:field name="pk"/>
<yss:field name="approvalStatus"/> *********** Enum Data type**********
<yss:sort-field name="name" asc="true"/>
</yss:simple-search>
Error :
ERROR [hybrisHTTP38] [FlexibleSearch] Flexiblesearch error: SQL search error : incompatible data type in operation query = 'SELECT item_t0.PK FROM products item_t0 LEFT JOIN productslp lp_t0_l1 ON item_t0.PK = lp_t0_l1.ITEMPK AND lp_t0_l1.LANGPK =? LEFT JOIN productslp lp_t0 ON at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$2.execute(DefaultFlexibleSearchService.java:384) at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$2.execute(DefaultFlexibleSearchService.java:1) at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.executeInLocalView(DefaultSessionService.java:88) at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService.getJaloResult(DefaultFlexibleSearchService.java:363) at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService.search(DefaultFlexibleSearchService.java:164) at de.hybris.platform.genericsearch.impl.DefaultGenericSearchService$1.execute(DefaultGenericSearchService.java:108) at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.executeInLocalView(DefaultSessionService.java:88)
Kindly help on this issue.
Thanks in advance. Anjan