Lucene: sort by numeric field

Question

I am trying to sort results by a decimal field, but it doesn't work. I need to use the property name indexer on the standard SearchResultItem so that it can be dynamic.

return queryable.OrderBy(i => i["price"]);

I have a string & DateTime fields that work fine using:

return queryable.OrderBy(i => i["date"]);
return queryable.OrderBy(i => i["title"]);

Config:

<field fieldName="price" 
   storageType="YES" 
   indexType="UNTOKENIZED" 
   vectorType="NO" 
   boost="1f" 
   type="System.Single" settingType="Sitecore.ContentSearch.LuceneProvider.LuceneSearchFieldConfiguration, Sitecore.ContentSearch.LuceneProvider" />`

I have also tried System.Double , System.Decimal for the type but still no luck.

Update: field in Luke:

Answer 1

If your property name has to be dynamic, You could try the following code for sorting on numeric field:

return queryable.OrderBy(i => (double)i[(ObjectIndexerKey)"price"]);

Set Your field config to use System.Double :

<field fieldName="price" 
   storageType="YES" 
   indexType="TOKENIZED" 
   vectorType="NO" 
   boost="1f" 
   type="System.Double" settingType="Sitecore.ContentSearch.LuceneProvider.LuceneSearchFieldConfiguration, Sitecore.ContentSearch.LuceneProvider" />

You can ask Sitecore to use IndexFieldFloatingPointNumberValueConverter as default converter for any double value using this Patch file:

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/">
  <sitecore>
    <contentSearch>
      <indexConfigurations>
        <defaultLuceneIndexConfiguration>
          <indexFieldStorageValueFormatter>
            <converters>
              <converter handlesType="System.Double" typeConverter="Sitecore.ContentSearch.LuceneProvider.Converters.IndexFieldFloatingPointNumberValueConverter , Sitecore.ContentSearch.LuceneProvider" />
            </converters>
          </indexFieldStorageValueFormatter>
        </defaultLuceneIndexConfiguration>
      </indexConfigurations>
    </contentSearch>
  </sitecore>
</configuration>

EDIT: I changed the field to be TOKENIZED as this is how it should be