[Koha-bugs] [Bug 5527] Reports: Patrons who haven't checked out misses active users from issues table
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Dec 20 23:23:20 CET 2010
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527
--- Comment #3 from Katrin Fischer <katrin.fischer at bsz-bw.de> 2010-12-20 22:23:19 UTC ---
I was looking at an older version of this script earlier today, but didn't
realize.
I still see some problems:
- the date is not showing up in the query
- the issues table is still not considered
SELECT CONCAT( borrowers.surname , "\t",borrowers.firstname, "\t",
borrowers.cardnumber)
FROM borrowers
WHERE 1 AND borrowers.borrowernumber not in
(SELECT DISTINCT borrowernumber
FROM old_issues
WHERE borrowernumber IS NOT NULL )
group by borrowers.borrowernumber
--
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
More information about the Koha-bugs
mailing list