But if I index $1234.56 as "123456", won't it affect the search or facet if I do a query directly to Solr?
Say if I search for index with amount that is lesser that $2000, it will not match, unless when we do the search, we have to pass "200000" to Solr? Regards, Edwin On 7 December 2016 at 07:44, Chris Hostetter <hossman_luc...@fucit.org> wrote: > : Thanks for your reply. > : > : That means the best fieldType to use for money is currencyField, and not > : any other fieldType? > > The primary use case for CurrencyField is when you want to do dynamic > currency fluctuations between multiple currency types at query time -- but > to do that you either need to use the FileExchangeRateProvider and have > your owne backend system to update the exchange rates, or you have to have > an openexchangerates.org account, or implement some other provider (with > custom solr java code) > > > If you only care about a single type of currency -- for example, if all > you care about is is US Dollars -- then just use either > TrieIntField or TrieLongField and represent in the smallest possible > increment you need to measure -- for US Dollars this would be cents. ie: > $1234.56 would be put in your index as "123456" > > > > -Hoss > http://www.lucidworks.com/ >