[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