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

[Former Member]

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

[jdejerphanion]

The only solution is to change the relation to a N:N. Like that you will have you're search attributes.

[jdejerphanion]

Do you find an answer at your problem ?

We have a similar issue here, it could help us if you have a solution.

Regards.