| Summary: | Most-circulated items report doesn't work when limited by library | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Nicole C. Engard <nengard> |
| Component: | Reports | Assignee: | Galen Charlton <gmcharlt> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | P5 - low | CC: | dpavlin, veron |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
I added a date range for the checkout dates and limit by item type: I get results. Same date range, but with limit by library: CGI::Compile::ROOT::kohadevbox_koha_reports_cat_issues_top_2epl::calculate(): DBI Exception: DBD::mysql::st execute failed: called with 1 bind variables when 0 are needed at /kohadevbox/koha/reports/cat_issues_top.pl line 59 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 |
I got this from a library: I'm trying to get the "Most Circulated Items" report to give me something and I am not having success. I chose a date range of 4 months, then I chose a library, then I chose a single item type (DVD1week) then I chose 20 for the limit, then I chose "library" for the "By" part of the limit and go an empty list. So I went back and changed "library" to "Itemtype." Now the system just hangs up spinning away without ever giving results. I wrote this to help for now - but the canned report should work: SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode FROM statistics s JOIN items i USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE DATE(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 4 MONTH) AND DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL AND i.itype=<<Item type|itemtypes>> AND i.hombranch=<<Home branch|branches>> GROUP BY b.biblionumber ORDER BY circs DESC LIMIT 20