[Koha-bugs] [Bug 10064] add category filter to Top Most-circulated items

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10064

Dobrica Pavlinusic <dpavlin at rot13.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #1 from Dobrica Pavlinusic <dpavlin at rot13.org> ---
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

-- 
You are receiving this mail because:
You are watching all bug changes.