Category: Koha Reports


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/’, biblio.biblionumber,'”>’,biblio.biblionumber,'</a>’) AS biblionumbers, items.barcode, items.itemcallnumber, biblioitems.isbn,, biblio.title, biblioitems.pages, biblioitems.publishercode,, 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’, […]