[Koha-bugs] [Bug 19021] Inventory column sorting

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19021

--- Comment #14 from David Cook <dcook at prosentient.com.au> ---
I need to do more investigation, but here's the relevant SQL query:

SELECT items.itemnumber, barcode, itemcallnumber, items.cn_sort, title, author,
biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location,
notforloan, damaged, itemlost, withdrawn, stocknumber, ccode
FROM items
LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber
LEFT JOIN biblioitems on items.biblionumber = biblioitems.biblionumber
WHERE ccode = ? AND items.homebranch = ? ORDER BY items.cn_sort,
itemcallnumber, title

I have different items with the same itemcallnumber values but different
cn_sort values, so they get sorted into different parts of the list, which are
completely not intuitive to the user.

This patch's template fix remedies that on the user interface but not in the
exported shelf list. 

I'm going to check into this more this afternoon...

-- 
You are receiving this mail because:
You are watching all bug changes.