Re: Sort by currency field using OpenExchangeRatesOrgProvider

[Chris Hostetter <ho...@fucit.org>]

: I have as part of my schema one currency field.
	...
: IT works properly when i filter or do a query using an specific currency.
	...
: But when I try to sort by this field it returns the results by amount and it
: doesn't take in consideration the currency.
	...
: Do you know if there is a bug around this?

Hmmm, do you only see this problem with the OpenExchangeRatesOrgProvider? 
have you tried reproducing it with the FileExchangeRateProvider ?

The provider used shouldn't have any effect on wether the sorting code 
works, but there also don't seem to be any tests actaully excercising the 
OpenExchangeRatesOrgProvider, so it's possible that there might be some 
bugs (i created SOLR-4514 for that) but doing some adhoc testing i 
couldn't find any.

Here's what i tried...


using the 4x checkout, i added teh following the example schema...

  <dynamicField name="*_oer_c" type="oer_currency" indexed="true"  stored="true"/>
    ...
  <fieldType name="oer_currency" class="solr.CurrencyField" precisionStep="8" defaultCurrency="USD" providerClass="solr.OpenExchangeRatesOrgProvider" ratesFileLocation="../../../../core/src/test-files/solr/collection1/conf/open-exchange-rates.json" />

...and then indexed three simple docs (see below), and queried them with 
asc and desc orders on the currency field -- based on the ordering 
returned in each case, it definitley appears to be paying attention to the 
currency conversion...

http://localhost:8983/solr/select?q=*:*&sort=price_oer_c+desc&wt=json&indent=true&omitHeader=true

{
  "response":{"numFound":3,"start":0,"docs":[
      {
        "id":"euro",
        "price_oer_c":"0.9,EUR",
        "_version_":1428268201637052416},
      {
        "id":"doller",
        "price_oer_c":"1,USD",
        "_version_":1428268009579872256},
      {
        "id":"yen",
        "price_oer_c":"1.5,JPY",
        "_version_":1428268193079623680}]
  }}

http://localhost:8983/solr/select?q=*:*&sort=price_oer_c+asc&wt=json&indent=true&omitHeader=true

{
  "response":{"numFound":3,"start":0,"docs":[
      {
        "id":"yen",
        "price_oer_c":"1.5,JPY",
        "_version_":1428268193079623680},
      {
        "id":"doller",
        "price_oer_c":"1,USD",
        "_version_":1428268009579872256},
      {
        "id":"euro",
        "price_oer_c":"0.9,EUR",
        "_version_":1428268201637052416}]
  }}


...can you give us more details about the specifics of what data you are 
using and what results you are seeing when you sort on it?






-Hoss