Accession Register Sorted by Barcode Number Report

Accession Register Sorted by Barcode Number Report

Module: Catalogue

SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers, 

       items.barcode, items.dateaccessioned, items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, biblioitems.pages, 

       biblioitems.publishercode, biblioitems.place, biblio.copyrightdate 

FROM items 

LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) 

LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) 

WHERE items.homebranch =<<Branch|branches>> 

ORDER BY LPAD(items.barcode,40,' ') asc

Accession/barcode number search

SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers, items.barcode,items.dateaccessioned,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate

FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)

WHERE items.homebranch =<<Branch|branches>> AND items.barcode LIKE <<Enter Barcode>>

ORDER BY LPAD(items.barcode,30,' ') ASC