Bug 22129

Summary: Report 1.3.3 Patrons Whose Age Violates Category Age Limits (finds nothing /is faulty)
Product: Koha Reporter: Heinrich Hartl <Heinrich.Hartl>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: katrin.fischer
Version: 18.05   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

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).