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

--- Comment #3 from Katrin Fischer <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to