[Koha] Help with a circulation report.

[Nicole Engard]

Katy,

There are many ways to show this, do you just want the titles? Do you
want call numbers?

Here's a list of patrons and checked out items:

SELECT issues, biblio.title, author, surname, firstname,
         items.itemcallnumber, items.barcode, issues.issuedate,
issues.lastreneweddate
  FROM issues
  LEFT JOIN borrowers ON borrowers.borrowernumber=issues.borrowernumber
  LEFT JOIN items ON issues.itemnumber=items.itemnumber
  LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber
  ORDER BY issues.branchcode, borrowers.sort1, borrowers.surname,
issues.issuedate, biblio.title

Or you can do this to get titles and call numbers of all items checked
out (in no order):

select biblio.title, items.itemcallnumber from issues left join items
on (items.itemnumber=issues.itemnumber) left join biblio on
(biblio.biblionumber=items.biblionumber)

If you're more specific I can get you just the right report

Thanks
Nicole C. Engard, ByWater Solutions

2011/4/1 Gunville, Katy <kgunvill at fhcrc.org>:
> Hello!
>
>
>
> We are new to KOHA.  Can anybody help us to run a basic list of all books
> currently checked out?  This should be a simple report and we are having a
> hard time with it.
>
>
>
> Thanks!
>
>
>
> Katy Gunville
>
> Arnold Library
>
> Fred Hutchinson Cancer Research Center
>
> 1100 Fairview Avenue North, B1-010
>
> P.O. Box 19024
>
> Seattle, WA 98109-1024
>
> Library (206) 667-4314
>
> Direct   (206) 667-5017
>
> kgunvill at fhcrc.org
>
>
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>