Bug 10064

Summary: add category filter to Top Most-circulated items
Product: Koha Reporter: Dobrica Pavlinusic <dpavlin>
Component: ReportsAssignee: 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

    
Comment 1 Dobrica Pavlinusic 2013-06-12 13:55:41 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