[Bug 27712] New: Cannot use date parameters in SQL reports
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27712 Bug ID: 27712 Summary: Cannot use date parameters in SQL reports Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: joonas.kylmala@helsinki.fi QA Contact: testopia@bugs.koha-community.org CC: nick@bywatersolutions.com Depends on: 27380 Using the date parameter in SQL report doesn't work anymore after bug 27380 was merged, reverting the patches fixes problem. I'm not exactly sure what is it that causes the problem, Nick do you have any idea? To reproduce the problem create a new SQL report:
select * from biblio where datecreated = <<Day|date>>
and then run it with whatever date and you should get the error:
Can't locate object method "_columns" via package "02/16/2021" (perhaps you forgot to load "02/16/2021"?) at /kohadevbox/koha/Koha/Object.pm line 810
Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27380 [Bug 27380] Add option for taking a list parameter in reports -- 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=27712 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- I've added a fix on bug 27380 (Add missing use statement) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27712 --- Comment #2 from Joonas Kylmälä <joonas.kylmala@helsinki.fi> --- Applying the patch from there fixes the issue indeed, thanks Jonathan for the super fast patch! :) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org