Kbase P131878: How do I search for attribute name/value pairs in my EasyAsk index?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/3/2008 |
|
Status: Unverified
GOAL:
How do I search for attribute name/value pairs in my EasyAsk index?
FACT(s) (Environment):
EasyAsk Versions
CAUSE:
When attributes are brought into an index from the database via an attribute query, all the attribute values are associated with a product but the actual attribute name is not tied to the attribute value. Even though the attribute query may retrieve an attribute name and attribute value from the database from a single row in your relational database it does not establish that relationship in the index. The index associates all the text from the attribute queries to the products so that it can text search for each and every value.
For example, if searching for Attribute Name = 'Size' and Attribute Value = '10' and Attribute Name = 'fabric' and Attribute Value= 'cotton', Easyask will find all products that have these column values. You could get a product who has an Attribute Name = 'Size' and Attribute Value = '12' and an Attribute Name = 'Inseam' and an Attribute Value = '10' and Attribute Name ='fabric' and an Attribute Value = 'cotton'.
FIX:
Establish an attribute relationship using virtual attribute tables. To create Virtual Attribute tables. Open DataWorkshop in database mode, go to Merchandising Manager, and create a new attribute using the attribute name from your attribute query. (for example, Size). Then select your new attribute and create a Virtual Table. Now, a search for Size = 10 will search for products whose attribute name is Size and has a matching attribute value of '10'