[Bug 33694] New: Incorrect sorting of call numbers in shelf browser
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33694 Bug ID: 33694 Summary: Incorrect sorting of call numbers in shelf browser Change sponsored?: --- Product: Koha Version: 22.05 Hardware: Other OS: Linux Status: NEW Severity: minor Priority: P5 - low Component: OPAC Assignee: oleonard@myacpl.org Reporter: anke.bruns@gwdg.de QA Contact: testopia@bugs.koha-community.org (Not sure if this is related to Bug #14907) In the view of a record in OPAC, there is a link "Browse Shelf" next to the call number in the item information. The surrounding records displayed are sorted by their call number but not correctly, e.g. 2 comes after 19, and 16 after 159, whereas it should sort numerically like this: 2 - 19 and 16 - 159. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33694 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Just to check: does the sorting work ok for you in other places? For example the inventory list? You could also try a report like this: select cn_source, cn_sort, itemcallnumber from items order by cn_sort This should reflect how Koha thinks the callnumbers should be sorted. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33694 --- Comment #2 from Anke Bruns <anke.bruns@gwdg.de> --- With the SQL query, I get results sorted in the same (numerically incorrect) way as described. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33694 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I don't believe it's a bug then, it's a configuration issue. Koha will generate a sorting form of your callnumber (itemcallnumber) from the classification source (cn_source). It's saved to cn_sort and used in a lot of places for sorting callnumbers. If you check the manual for classification sources, you'll find information there about the 3 algorithms Koha has to do that (DDC, LOC and generic). Sadly no RVK and similar yet (I'd be happy to see that added :) ) -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org