[Koha] Item Return Date
Owen Leonard
oleonard at myacpl.org
Tue Aug 30 02:01:05 NZST 2011
> I would like to generate a report based on all the returned books on a
> specify date
Returns are tracked in the statistics table, where the 'type' column
contains 'return,' and the return date is in the 'datetime' column.
I'm not good at efficient SQL, so I won't try to suggest a query that
returns user-friendly data from biblio (for instance). You can get
more ideas from the SQL reports library:
http://wiki.koha-community.org/wiki/SQL_Reports_Library
-- Owen
--
Web Developer
Athens County Public Libraries
http://www.myacpl.org
More information about the Koha
mailing list