[Koha-bugs] [Bug 7014] sorting of call numbers in Inventory tool is not correct

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7014

D Ruth Bavousett <ruth at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ruth at bywatersolutions.com

--- Comment #2 from D Ruth Bavousett <ruth at 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.