http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7014
D Ruth Bavousett <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from D Ruth Bavousett <[email protected]> --- One of our libraries has a series designation on their fiction, like F BALDACCI, D / KING #. All of the titles with series designations are showing up at the first of the inventory list, when they should show up *after*. Since they do that if you sort a hitlist by call number, as well, I don't think the problem is in inventory, per se, but in the generation of ddc cn_sort values. Indeed, in this case, I see this: select itemcallnumber,cn_sort,cn_source from items where itemcallnumber like "A/T BALD%"; +---------------------------+--------------------------------+-----------+ | itemcallnumber | cn_sort | cn_source | +---------------------------+--------------------------------+-----------+ | A/T BALDACCI, D | AT_BALDACCI_D | ddc | | A/T BALDACCI, D | AT_BALDACCI_D | ddc | | A/T BALDACCI, D | AT_BALDACCI_D | ddc | | A/T BALDACCI, D / CAMEL 1 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / CAMEL 2 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / CAMEL 3 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / CAMEL 4 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / CAMEL 5 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / KING 1 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / KING 2 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / KING 3 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / KING 4 | AT_000000000000000_BALDACCI_D_ | ddc | | A/T BALDACCI, D / KING 5 | AT_000000000000000_BALDACCI_D_ | ddc | +---------------------------+--------------------------------+-----------+ It's a little more complicated problem than I'd hoped for, and I'd like to check this against similar values to Cindy and Melia, but that is definitely a direction for investigation. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
