Category: Koha Reports

27/08/2020

Koha Reports – Tested with Koha 20.05

Koha Reports: You can easily add customized reports in your Koha Software. Accession Register (Complete List of Books-Sorted by Barcode) SELECT CONCAT(‘<a href=”/cgi-bin/koha/catalogue/detail.pl?biblionumber=’, biblio.biblionumber,'”>’,biblio.biblionumber,'</a>’) AS biblionumbers, items.barcode, items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, biblioitems.pages, biblioitems.publishercode, biblioitems.place, biblio.copyrightdate,items.price FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) ORDER BY LPAD (items.barcode,40,’ ‘) ASC Detailed Accession Register Report SELECT oo.dateaccessioned AS ‘Date’, oo.barcode AS ‘Acc. No./Barcode’, […]