Search product by it's classification attribute

[former_member683174]

Hi,

Is it possible to configure advanced search for product so product can be searched by classification attributes?

Hybris version 1808

Thanks, Josip

[former_member506]

Hello
I too have same question, did you find out please.

Thanks.

[former_member506]

May be you can use Product relation(1:n) with Product Feature for this purpose, based on below.
Try it.

SELECT 
     {p.code}, {pf.qualifier}, {pf.stringValue}
 FROM 
     {ProductFeature as pf 
     JOIN Product as p ON {p.pk}={pf.product}