[Koha] Item Return Date
Owen Leonard
oleonard at myacpl.org
Mon Aug 29 14:01:05 UTC 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