Kbase P121985: EasyAsk formula does not generate search results
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/1/2007 |
|
Status: Unverified
FACT(s) (Environment):
EasyAsk
EasyAsk 9.4
SYMPTOM(s):
No results for a search on Winter Clearance in index mode
Definitions: Winter Clearance is a value of 1Hidden Concepts
Formulas: WClearanceFormula ((orig retail - retail)/orig retail)
WClearanceFormula2 ifa(WClearanceFormula >= .50, 'Winter Clearance', '')
FIX:
Create a text query that includes WClearanceFormula2, add the text query to the Index Build.
Some older builds of EasyAsk 9.4 will require that WClearanceFormula2 properties are soft comparison so that the sql that is generated uses contains rather than equality (the most recent build of EasyAsk 9.4 does not require this)
Use Merchandising Manager to define the attribute Winter Clearance under attribute 1Hidden Concepts and give it the definition wclearanceformula2 "winter clearance"
add wclearanceformula2 to default columns
create appropriate synonyms for winter clearance
save the dictionary, rebuild the index, and run the attribute utility