Re: Sorting fields of text_general fieldType

[Ahmet Arslan]

> The title sort works in a strange manner because the SOLR
> server treats
> title string based on Upper Case or Lower Case String. Thus
> if we sort in
> ascending order, first the title with numeric shows up then
> the titles in
> alphabetical order which starts with Upper Case & after
> that the titles
> starting with Lowercase.
> 
> The title field is indexed as text_general fieldtype.
> 
> <field name="title" type="text_general" indexed="true"
> stored="true"/>

Please see Otis' response http://search-lucene.com/m/uDxTF1scW0d2

Simply create an additional field named title_sortable with the following type 

 <!-- lowercases the entire field value, keeping it as a single token.  -->
    <fieldType name="lowercase" class="solr.TextField" 
positionIncrementGap="100">
      <analyzer>
        <tokenizer class="solr.KeywordTokenizerFactory"/>
        <filter class="solr.LowerCaseFilterFactory" />
        <filter class="solr.TrimFilterFactory" />
      </analyzer>
    </fieldType>

Populate it via copyField directive : 

  <copyField source="title" dest="title_sortable" maxChars="N"/>

then &sort=title_sortable asc