Hi all, I have this request for a report:
"Can you develop a report that would provide: all the holds for <<a chosen owning library's>> titles (also showing the item barcodes) on which <<the same chosen library's>> patrons have holds but which titles are “in transit" to another library?" The hold is placed on the biblio level most of the time and and transfer on the item level - so this report will not be comprehensive because it will only find item specific holds. SELECT b.title, b.author, i.itemcallnumber, i.barcode, t.tobranch, COUNT(h.biblionumber) AS 'holds' FROM reserves h LEFT JOIN borrowers p using (borrowernumber) LEFT JOIN branchtransfers t USING (itemnumber) LEFT JOIN items i ON (t.itemnumber=i.itemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE i.homebranch = <<Item's branch|branches>> and p.branchcode=i.homebranch and p.branchcode != t.tobranch GROUP BY h.biblionumber HAVING COUNT(h.biblionumber) > 0 ORDER BY b.title ASC Is there a way to make it more comprehensive that I'm missing? Thanks Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha