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

Lib Power Tech May 06, 2019
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
Lib Power Tech

Posted by Lib Power Tech

This situation will change

Post a Comment

1 Comments

  1. Richard FetzerJuly 26, 2025 at 4:25 PM

    Wow, this SQL report is super handy for librarians who want to keep track of newly added books in Koha by date! WebSpaceKit really helped me organize and manage my digital library setup more efficiently.

    ReplyDelete