Summary: | add category filter to Top Most-circulated items | ||
---|---|---|---|
Product: | Koha | Reporter: | Dobrica Pavlinusic <dpavlin> |
Component: | Reports | Assignee: | Dobrica Pavlinusic <dpavlin> |
Status: | CLOSED WONTFIX | QA Contact: | |
Severity: | enhancement | ||
Priority: | P5 - low | ||
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | Sponsored | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
Description
Dobrica Pavlinusic
2013-04-16 11:48:45 UTC
Easier solution (since we need custom columns anyway) was to create SQL report like this: 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 i.itype=<<Item type|itemtypes>> AND i.homebranch=<<Home branch|branches>> AND i.ccode=<<Collection|CCODE>> GROUP BY b.biblionumber ORDER BY circs DESC |