Bug 22129 - Report 1.3.3 Patrons Whose Age Violates Category Age Limits (finds nothing /is faulty)
Summary: Report 1.3.3 Patrons Whose Age Violates Category Age Limits (finds nothing /i...
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: 18.05
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-14 18:41 UTC by Heinrich Hartl
Modified: 2020-06-04 20:32 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Heinrich Hartl 2019-01-14 18:41:06 UTC
The report is faulty: For MaxAge a value specified correctly in the category is overidden and replaced by 999. Therefore no violation of MaxAge is found by this report.
I made a quick and dirty correction:

$ diff Rep*
7c7,8
<    GREATEST ( c.upperagelimit, 999 ) AS MaxAge,
---
> #   GREATEST ( c.upperagelimit, 999 ) AS MaxAge,
>     c.upperagelimit AS MaxAge,

19c20,23
< #   age NOT BETWEEN MinAge AND MaxAge
---
>   age < MinAge or ( age > MaxAge And Maxage > 0 )
Comment 1 Katrin Fischer 2019-08-18 08:29:27 UTC
I've edited the report in the wiki after confirming the changes:
https://wiki.koha-community.org/wiki/SQL_Reports_Patrons#Patrons_Whose_Age_Violates_Category_Age_Limits

Thx for sharing the solution!

Problems with the wiki content are usually not reported with bugzilla, but can be fixed directly with an account on the wiki. Getting a new account request moderated can take a little while (spam protection measures).