Bug 10064 - add category filter to Top Most-circulated items
Summary: add category filter to Top Most-circulated items
Status: CLOSED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Dobrica Pavlinusic
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-16 11:48 UTC by Dobrica Pavlinusic
Modified: 2014-12-07 20:02 UTC (History)
0 users

See Also:
Change sponsored?: 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 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