Bug 27712 - Cannot use date parameters in SQL reports
Summary: Cannot use date parameters in SQL reports
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 27380
Blocks:
  Show dependency treegraph
 
Reported: 2021-02-16 08:57 UTC by Joonas Kylmälä
Modified: 2021-12-13 21:08 UTC (History)
2 users (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 Joonas Kylmälä 2021-02-16 08:57:41 UTC
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
Comment 1 Jonathan Druart 2021-02-16 09:16:25 UTC
I've added a fix on bug 27380 (Add missing use statement)
Comment 2 Joonas Kylmälä 2021-02-16 09:23:16 UTC
Applying the patch from there fixes the issue indeed, thanks Jonathan for the super fast patch! :)