http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10064
Dobrica Pavlinusic <dpav...@rot13.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WONTFIX
--- Comment #1 from Dobrica Pavlinusic <dpav...@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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
