[Koha-bugs] [Bug 10154] Add Call number in the filter of most circulated items
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Oct 28 21:51:05 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10154
--- Comment #3 from Eivin Giske Skaaren <eivin at sysmystic.com> ---
Created attachment 44135
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=44135&action=edit
Bug 10154 Add Call number in the filter of most circulated items
This patch adds call number, collection code and shelving location to the
filter.
To test:
It is of course a prerequisite to have items in the DB with the correct MARC
fields
and that they have been checked out etc. to get a valid result when testing.
1. Apply patch to koha synced to master.
2. Go to /cgi-bin/koha/reports/cat_issues_top.pl
3. Select filters, the new ones are Call number, Collection code and Shelving
location
4. Hit submit.
Expected result:
The filters chosen will be printed under "Filtered on".
A table with the result is shown.
For manual verification here is some SQL to run:
SELECT DISTINCT biblio.title, COUNT(biblio.biblionumber) AS RANK,
biblio.biblionumber AS ID, itemcallnumber as CALLNUM, ccode as CCODE, location
as LOC FROM `old_issues`
LEFT JOIN items USING(itemnumber)
LEFT JOIN biblio USING(biblionumber)
LEFT JOIN biblioitems USING(biblionumber)
LEFT JOIN borrowers USING(borrowernumber)
WHERE 1 AND biblioitems.itemtype like 'BK' AND itemcallnumber
like '005.2/762' AND ccode like 'NFIC' AND location like 'CART' AND
borrowers.categorycode like 'PT' group by biblio.biblionumber order by RANK
DESC;
Put in your valid values in the WHERE clause for the values in the single
quotes ''.
Sponsored-by: Halland county library
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list