I am having one use case regarding currency based search. I want to get any suggestions or pointers..
For example, Assume, 1USD = 75 INR 1USD = 42190 IRR similarly, we have support for 100 currencies as of now. Record1 created with PRICE 150 INR & EXCHANGE_RATE 75 for USD Record2 created with PRICE 84380 IRR & EXCHANGE_RATE 42190 for USD If i search 2 ( USD ), I would like to get both Record1 & Record2 as search results PRICE & EXCHANGE_RATE are indexed & stored as separate fields in the search index We can have 50 number of currency fields like PRICE. so we may need to index additional 50 fields holding USD values. To avoid additional fields, Is it possible to match records in the search index by applying an expression like (PRICE / EXCHANGE_RATE ) I am not sure if this is the right use case for Lucene index. But I would like to know the possibilities. Thanks in advance -- Kumaran R Chennai, India
