https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19021
--- Comment #14 from David Cook <[email protected]> --- 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. _______________________________________________ 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/
