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