Maybe the select suggested in the wiki SELECT items.price,items.replacementprice,biblio.title,biblio.author,items.itemcallnumber FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch=<<Home branch|branches>> ORDER BY items.itemcallnumber ASC
could be enhanced using the cn_sort field, that cointains the sort form of itemcallnumber, changing the ORDER BY clause into ORDER BY items.cn_sort ASC Stefano > There is a report for a complete shelf list on the wiki - > http://wiki.koha-community.org/wiki/SQL_Reports_Library#Complete_Shelf_list > > You should be able to use that as a starting place to get what you're > looking for. > > Liz Rea _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
