I'm looking for a report that shows items that have holds on them where there are no other items available at the branch. Available being checked in and not lost.
I was using this report as a starting point. SELECT i.itemnumber, i.reserves, i.issues, i.datelastseen, i.dateaccessioned, i.ccode, b.title, b.author, i.itemcallnumber, i.barcode, v.lib, IF(h.reservedate IS NULL, '', 'on hold') AS holds FROM items i LEFT JOIN biblio b USING (biblionumber) LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) LEFT JOIN reserves h ON (b.biblionumber=h.biblionumber) WHERE i.itemlost != 0 AND v.category='LOST' and i.homebranch=<<Item's branch|branches>> Thanks in advance, Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha