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 <amutsik...@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
>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
