Summary: | Reports: Patrons who haven't checked out misses active users from issues table | ||
---|---|---|---|
Product: | Koha | Reporter: | Katrin Fischer <katrin.fischer> |
Component: | Reports | Assignee: | Katrin Fischer <katrin.fischer> |
Status: | CLOSED FIXED | QA Contact: | Bugs List <koha-bugs> |
Severity: | major | ||
Priority: | PATCH-Sent (DO NOT USE) | CC: | chris, julian.maurice, nengard |
Version: | rel_3_2 | ||
Hardware: | All | ||
OS: | All | ||
URL: | /cgi-bin/koha/reports/borrowers_out.pl | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: | ||
Attachments: |
screenshot of my report settings
Proposed patch |
Description
Katrin Fischer
2010-12-20 15:43:02 UTC
Created attachment 2892 [details]
screenshot of my report settings
Still fighting with this report: old_issues.timestamp> 01/01/2010 is not right and brings up a lot of 2009-* dates. :( Should be: old_issues.timestamp> "2010-01-01" 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 Created attachment 2897 [details] [review] Proposed patch This bug is mentioned in: Bug 5527: Fix some problems in inactive borrowers report http://lists.koha-community.org/pipermail/koha-patches/2010-December/013449.html Pushed, please test and mark resolved This bug is mentioned in: Bug 5527: Fix some problems in inactive borrowers report http://lists.koha-community.org/pipermail/koha-patches/2011-March/014004.html |