[Koha-bugs] [Bug 1824] pending reserves shows *everything* will not work for large libraries

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1824





------- Comment #4 from drdrulm at yahoo.com  2008-03-21 10:10 -------
I am rewriting this. The patrons are irrelevant since they will come up on
check in correctly. The patrons *are* important for waitingreserves.pl but
there is a 1-1 relationship patron to item.

This is not an easy one, however, if it is really to be done correctly, there
can be multiple database queries and item information filtered as needed. I
have a good report that is doing what it is supposed to be doing -yes in Perl
(same as any other imperative language, some different syntax, no big!) ;)

The main point of the report is to provide a list of 
1. How many books to pull
2. Show available books AND LOCATIONS
   note: without (holding-library/location/itype/and call) the book is not
   going to be easy to find. Example: title:"Trucks," with call 623.324. So 
   it is Non Fic, but is it a book, video, what?

I created a report in the last hour and called it "newpendingreserves.pl/tmpl"

It filters out the:
Waiting - (why would a librarian need to pull it if waiting?, 
          makes counting number to pull more difficult!
Uses Distinct - Keeps out the dups
Groups By Reserves.biblionumber (I had barcode in there
before-whoops!-T-Y-P-O!)
Only select if not damaged, lost, wthdrawn, or not for loan.
Also make sure the item is not in a Truck (branch Transfers)

It is working well for my setup at Stow.

Goede dag

Submitting shortly.

Goede dag! :]




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.