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

1. Who has issued the given barcoded book? and when? 2. What are the books issued by staff-ID( with time) ? You might something in the SQL Reports Library that may help: http://wiki.koha-community.org/wiki/SQL_Reports_Library Regards. (Sending to the list this time) David Nind |

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

Hi Please help me to find solutions bellow matter Recently our library had a problem of issuing a few books to wrong patrons' name by a staff member in circulation counter ( nearly 15 staff member work in the desk in time to time /month as we have roster based duties in the counter)

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

hiii, Please find below the report which we are using to check the actions taken in our library, it is datewise report in descending order: IF(a.action=ISSUE, CONCAT('a href=\/cgi-bin/koha/reports/ guided_reports.pl?phase=Run+this+reportreports=1275sql_params=',a.info,' \Checkout Details/a'),