[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