[Koha] Report: patrons with recent checkouts

Chad Roseburg croseburg at ncrl.org
Fri Dec 6 16:28:44 NZDT 2013


I'm doing a report that looks for patrons in a given branch that have
checked out items after a
specified date. Does this look right?

SELECT count( distinct b.borrowernumber )
FROM borrowers b
JOIN old_issues i USING (borrowernumber)
WHERE b.branchcode = 'WENATCH'
AND i.issuedate > '2012-12-05';

Thank you!

Chad

-- 
Chad Roseburg
Automation Dept.
North Central Regional Library


More information about the Koha mailing list