I think that the simplest query for this would be a modification of https://wiki.koha-community.org/wiki/SQL_Reports_Library#Track_In_House_Use Replace count(*) with barcode, and modify the WHERE clause to search for 'isssue' instead of 'localuse'. SELECT count(*) FROM statistics WHERE type='localuse' AND datetime BETWEEN <<Local USE BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> You'll have to do either a left join or an inner join on items to get the barcode field. SELECT barcode FROM statistics INNER JOIN items USING (itemnumber) WHERE type='issue' AND datetime BETWEEN <<Check outs between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> On Tue, Jun 7, 2016 at 5:36 AM, Admire Mutsikiwa <amutsikiwa@uzlib.uz.ac.zw> wrote:
Hi
I am interested in generating a barcode list of records created by a given user ( as a function of borrower number) in a given time frame. I will appreciate an SQL statement that will enable me to achieve this.
Kind Regards,
Admire Mutsikiwa (Mr)
ICT Manager
Libraries
University of Zimbabwe
Tel:+263-4-303276
Mob:+263771117777
"It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha