[Bug 22129] New: Report 1.3.3 Patrons Whose Age Violates Category Age Limits (finds nothing /is faulty)
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22129 Bug ID: 22129 Summary: Report 1.3.3 Patrons Whose Age Violates Category Age Limits (finds nothing /is faulty) Change sponsored?: --- Product: Koha Version: 18.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: Heinrich.Hartl@email.de QA Contact: testopia@bugs.koha-community.org Target Milestone: --- 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 )
-- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22129 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I've edited the report in the wiki after confirming the changes: https://wiki.koha-community.org/wiki/SQL_Reports_Patrons#Patrons_Whose_Age_V... 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). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org