Bug 8306

Summary: Patron stats, patron activity : no active doesn't work
Product: Koha Reporter: Adrien SAURAT <adrien.saurat>
Component: ReportsAssignee: Adrien SAURAT <adrien.saurat>
Status: CLOSED FIXED QA Contact:
Severity: minor    
Priority: P5 - low CC: chris, jonathan.druart, julian.maurice, katrin.fischer, kyle, marc.sabin, mtj
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22082
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: proposed patch
Bug 8306: Patrons statistics, fix for patron activity choice
Bug 8306: Patrons statistics, fix for patron activity choice

Description Adrien SAURAT 2012-06-25 11:51:06 UTC
MT9357

In "Home › Reports › Patrons statistics", for the Patron activity, the "no active" choice doesn't work.
Comment 1 Adrien SAURAT 2012-12-13 09:22:29 UTC
Created attachment 14066 [details] [review]
proposed patch

TEST PLAN

1) Click on Reports -> Patrons to see the "Patrons statistics" page
2) Setup a request which should have result for both inactive and active patrons. For example, select "Patron category" as row and "Patron gender" as column.
3) Launch the request, then come back and select "active" in the "Patron activity" parameter. Launch the request again, the results should be different, displaying only active patrons.
4) Come back and select "inactive" in the "Patron activity" parameter. Launch the request. The results are empty ! After installing this patch you'll obtain stats for the inactive patrons.
Comment 2 Kyle M Hall 2012-12-14 15:51:27 UTC
I'm unable to reproduce this issue. I'm using the default patron data, which means many patrons without any activity. When I run the queries the 'active' has no results as expected, and the 'no active' gives me 50 total results. Am I testing this incorrectly?
Comment 3 Owen Leonard 2012-12-26 16:18:41 UTC
Following the test plan I get the same results (which appear to be valid) before and after the patch.
Comment 4 Marc Sabin 2013-03-07 09:47:02 UTC
Following the test plan, the 4th step (inactive) doesn't work :

either "no result" or "504 Gatewat Time Out".
Comment 5 Marc Sabin 2013-03-07 10:08:03 UTC
I've just test on a sandbox and the patch seems to work.

The last step (select "inactive" in the "Patron activity" parameter)
gives me the stats for the inactive patrons.
Comment 6 Jonathan Druart 2014-12-11 14:04:51 UTC
I can reproduce on the production server of the customer, maybe because of the high amount of data (17k users, 70k old_issues).

I confirm the result of the reports is the same before and after the patch (and I cannot reproduce on a local instance).
But it seems logical to me to exclude old_issues where borrowernumber is null (deleted patrons), don't you think?
Comment 7 Jonathan Druart 2014-12-11 14:09:16 UTC
Note that this could certainly be fixed on this specific installation if the nginx timeout is increased.
Comment 8 Julian Maurice 2017-01-12 12:50:56 UTC
This bug has been in discussion for almost 4 years. I don't see why a discussion is needed here. According to comments, either the patch fixes a bug or it changes nothing, depending on the database content.
Switching back to Needs signoff (patch still applies correctly)
Comment 9 Julian Maurice 2017-01-12 12:58:04 UTC
Created attachment 58874 [details] [review]
Bug 8306: Patrons statistics, fix for patron activity choice

The "inactive" for "patron activity" choice is now effective.

Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
Comment 10 Julian Maurice 2017-01-12 13:03:05 UTC
My test plan:
1. Create a borrower X
2. Check out an item to borrower X
3. Check in the same item
4. Delete borrower X

So now, I have an old_issues line with borrowernumber = NULL

5. Go to patron stats, Row = category, Column = library, Patron activity filter = no active ==> no results
6. Apply patch
7. Repeat 5 ==> results!
Comment 11 Nick Clemens 2017-02-03 11:14:42 UTC
Created attachment 59873 [details] [review]
Bug 8306: Patrons statistics, fix for patron activity choice

The "inactive" for "patron activity" choice is now effective.

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Comment 12 Kyle M Hall 2017-02-14 14:10:58 UTC
Pushed to master for 17.05, thanks Adrien!
Comment 13 Katrin Fischer 2017-02-14 20:51:28 UTC
This patch has been pushed to 16.11.x and will be in 16.11.04.
Comment 14 Julian Maurice 2017-02-20 09:58:15 UTC
Pushed to 3.22.x for 3.22.17
Comment 15 Mason James 2017-02-23 20:22:00 UTC
Pushed to 16.05.x, for 16.05.10 release