[Koha-bugs] [Bug 35051] Reservations Notification for return shelf

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35051

--- Comment #3 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
The report would be written with SQL with the columns you want to display and
added to the "Saved reports". Have a look at the reports module - it's super
useful. It could look a bit like this:

select 
(select title from biblio bi where bi.biblionumber = i.biblionumber) as Titel,
i.itemcallnumber as Signatur,
i.barcode AS Barcode,
r.borrowernumber AS Benutzernummer,
r.reservedate AS Vormerkdatum, 
r.biblionumber AS Titelsatznummer, 
r.timestamp AS Zeitstempel
from 
items i,
reserves r 
where r.found = 'P'
and i.biblionumber = r.biblionumber
order by r.timestamp DESC

The interesting bit here is the 'where reserves.found = "P"'

If you go the easier route, a link could be added using the 
IntranetmainUserblock or IntranetNav system preferences.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.