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
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