[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
Mon Nov 16 19:15:30 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10154
Eivin Giske Skaaren <eivin at sysmystic.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #44879|0 |1
is obsolete| |
--- Comment #5 from Eivin Giske Skaaren <eivin at sysmystic.com> ---
Created attachment 44880
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=44880&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
Fixed patch did not apply.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list