New Books Entry in Date wise List of Books (Koha SQL Reports Queries)

Add the New Books in koha  Date wise List of Books

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT items.dateaccessioned,items.barcode,items.itemcallnumber,biblio.author,biblio.title,biblioitems.publishercode FROM items

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

LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.dateaccessioned BETWEEN

<<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>>

ORDER BY items.barcode DESC

Run Report