[Koha] Reports - Check-in

Owen Leonard oleonard at myacpl.org
Wed Sep 4 00:37:36 NZST 2019

> I would like to run a report in which I could trace all the books/barcodes
> that haven't been checked-in, in a specific period.

It sounds like you're looking for an inventory report. There are some
on the wiki:


Adapting "Inventory report"
might give you what you want:

SELECT b.title, i.barcode, i.itemcallnumber, i.itemlost, i.damaged,
 FROM biblio b
 LEFT JOIN items i USING (biblionumber)
 WHERE i.onloan IS NULL AND datelastseen < <<Last seen before
                 AND i.homebranch=<<Home branch|branches>>
 ORDER BY datelastseen DESC, i.itemcallnumber ASC

  -- Owen

Web Developer
Athens County Public Libraries

More information about the Koha mailing list