Did you actually get a working filter on productAttributes? How did you achieve this?
I'm trying to do such a thing, and have added a record to the BLC_FIELD table with ENTITY_TYPE = PRODUCT and PROPERTY_NAME = productAttribute.attri1. Am I correct when assuming that attri1 is the key of the attribute I'm trying to query?
I also had to add a record to the BLC_FIELD_SEARCH_TYPES table having a reference to my newly created record in BLC_FIELD and with a SEARCHABLE_FIELD_TYPE 't'
Finally, in order to make the field facetable, I created a global search facet record in BLC_SEARCH_FACET. The above steps however didn't have an effect. Searching on a value of an attribute did not work..
Do you have any ideas/hints to help me further?
Thx in advance!
pluto wrote:Hey Philipuniverse,
I' m sorry for the late reply.
I understand the documentation but I can't find the solution for my problem.
When I use attributes I can simply create a filter when I create a blc_field in the database with entity_type PRODUCT and property_name productAttributes.attri1
But now I want to extend Product with an extra field attri1. So how can I do the filtering on that?
Will the entity type stays PRODUCT do I need the use the name of the new entity?
How to name the property_name?
I tried a few combinations but can't figure it out.
Or do I need to change something else?