[Koha] call number sort problem

[Bruce A Metcalf]

Fridolin SOMERS <fridolin.somers at biblibre.com> wrote:

> Look into database the values of items.cn_sort for thoses callnumbers.

The call numbers are fine. It's the sorting sequence I wanted to change.

As in my previous post, I effected this by changing to a different set  
of "Classification Filing Rules". "LCC" did what I wanted, "Generic"  
did not.

Regards,
/ Bruce /
Bruce A. Metcalf
Librarian
The Augustan Society, Inc.

> Le 11/06/2014 05:29, Bruce A Metcalf a écrit :
>> Fridolin SOMERS <fridolin.somers at biblibre.com> wrote:
>>> Le 21/03/2014 22:05, Margo Duncan a écrit :
>>>> We're having some issues with call number sort in our reports and
>>>> I'm wondering if anyone has any insights.
>>>>
>>>> It appears that cn_sort has two different methods of sorting call
>>>> numbers.  One way is that 0 is added so that a call number of
>>>> HD30.19 is HD003019.  The other way is with _ so HD30.19 is
>>>> HD_0030_19. ... So can I adjust the sorting  method, or is there
>>>> something wrong with my data?
>>>
>>> items.cn_sort calculation depends on items.cn_source value, if no
>>> value, the default classification source is used (defined in syspref
>>> "DefaultClassificationSource").
>>
>> I think I understand this, but I don't understand how to make a call
>> number like "H B34" sort before one like "HM B34".
>>
>> It seems the default is to sort spaces after letters and numbers (which
>> takes me all the way back to Hollerith sorts!).
>>
>> Can this be changed, and if so, how?
>>
>> Regards,
>> / Bruce /
>> Bruce A. Metcalf
>> Library Director
>> The Augustan Society, Inc.
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
> -- 
> Fridolin SOMERS
> Biblibre - Pôles support et système
> fridolin.somers at biblibre.com
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha