[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