http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7014 D Ruth Bavousett <ruth@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ruth@bywatersolutions.com --- Comment #2 from D Ruth Bavousett <ruth@bywatersolutions.com> --- 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.