Re: [Koha] SQL query: Who has issued the '1234' barcoded book? and when?

HRS [bala.allmail@gmail.com] wrote:

In looking SQL queries for

1. Who has issued the given barcoded book? and when? 2. What are the books issued by staff-ID( with time) ?

SELECT action_logs.timestamp, borrowers.userid, borrowers.firstname, borrowers.surname, action_logs.action, items.barcode, biblio.title FROM action_logs, borrowers, items, biblio WHERE action_logs.action = 'ISSUE' AND action_logs.user = borrowers.borrowernumber AND items.biblionumber = biblio.biblionumber AND items.itemnumber = action_logs.info This will list all issues. To search for a specific barcode just add a line like: AND items.barcode = 1234 To search for staff-ID add: AND borrowers.userid = 'example' Regards Holger