https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20961 Bug ID: 20961 Summary: cn_sort for DDC callnumbers should between 1 and 99 should be formatted as 001.* - 099.* Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs@lists.koha-community.org Reporter: barton@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org The documentation for C4::ClassSortRoutine::GetClassSortKey says * Concatenates class and item part. * Converts to uppercase. * Removes leading and trailing whitespace and '/' * Separates alphabetic prefix from the rest of the call number * Splits into tokens on whitespaces and periods. * Leaves first digit group as is. ... 9.1 => 9_100000000000000 80.1 => 80_100000000000000 700.1 => 700_100000000000000 when sorted ascending by cn_sort are 700.1 => 700_100000000000000 80.1 => 80_100000000000000 9.1 => 9_100000000000000 however, DDC classes are formatted 000 – Computer science, information & general works 100 – Philosophy and psychology 200 – Religion 300 – Social sciences 400 – Language 500 – Pure Science 600 – Technology 700 – Arts & recreation 800 – Literature 900 – History & geography 000 is sub-divided into the hundreds group 000 Computer science, knowledge & systems 010 Bibliographies 020 Library & information sciences ... and sub-sub-divided into the thousands groups... 000 Computer science, information & general works 001 Knowledge 002 The book 003 Systems ... As such, '* Leaves first digit group as is.', should read * the first digit group should be 3 characters wide, 0-padded I.e. the value of cn_sort for callnumber 1.1 should be 001_100000000000000, so that the examples above sort 009_100000000000000 080_100000000000000 700_100000000000000 See discussion here: http://lists.koha-community.org/pipermail/koha-devel/2018-June/044623.html And the summary of DDC 23 here: https://www.oclc.org/content/dam/oclc/dewey/DDC%2023_Summaries.pdf -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.