[Koha] Reports - Check-in

[Aliki]

Hello everybody!

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.
Is there any query that I could use to get the non checked-in
books/barcodes, except the checked-out ones?

-- 
Aliki Pavlidou
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Reports - Check-in

[Owen Leonard]

> 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:

https://wiki.koha-community.org/wiki/SQL_Reports_Library#Inventory.2F_Shelflists

Adapting "Inventory report"
(https://wiki.koha-community.org/wiki/SQL_Reports_Library#Inventory_Report)
might give you what you want:

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

  -- Owen

-- 
Web Developer
Athens County Public Libraries
https://www.myacpl.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha