Skip to Content
0
Former Member
Sep 25, 2014 at 06:25 AM

hmc search - adding product releations in "Search additional attributes..."

154 Views

I have a 1:n relation between product entity and another entity called replacement parts. replacement parts doesn't showup in "Search additional attributes..." . I even tried adding manually in hmc.xml but it fails

I know there must be a way because products can be searched with categories which has M:n relation. Please let me know if somebody has figured out adding relations to search conditions.

Exception while searching with replacement part

Caused by: java.sql.SQLSyntaxErrorException: incompatible data type in operation at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at de.hybris.platform.jdbcwrapper.ConnectionImpl.prepareStatement(ConnectionImpl.java:574) at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:109) ... 73 more Caused by: org.hsqldb.HsqlException: incompatible data type in operation at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypesForAllAny(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypesForComparison(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source) at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source) at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source) at org.hsqldb.QueryExpression.resolve(Unknown Source) at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatement(Unknown Source) at org.hsqldb.Session.compileStatement(Unknown Source) at org.hsqldb.StatementManager.compile(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 77 more