Good day Koha users and developers! I would like to share this mysql report that I came up to when my boss requested me to show all old circulation issues since the beginning. I went to the koha mysql report wiki but did not find what my boss wanted so I just created one and I'm sharing it. Here is the mysql query: SELECT old_issues.*, borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.sort1, borrowers.sort2, items.barcode, items.datelastborrowed, items.datelastseen, items.itemcallnumber, items.issues, items.holdingbranch, items.location, items.permanent_location, items.onloan, items.ccode, items.itype, items.enumchron, items.copynumber, items.location, b.totalissues, EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' ) as TITLE FROM old_issues LEFT JOIN borrowers ON ( borrowers.borrowernumber = old_issues.borrowernumber ) LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber ) LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber = b.biblioitemnumber)
-- View this message in context: http://koha.1045719.n5.nabble.com/All-old-circulation-issues-and-their-corresponding-borrowers-and-the-titles-of-the-items-borrowed-tp5752064.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
