[Koha] Collection usage report: issues field in items table
Galen Charlton
gmc at esilibrary.com
Sat Jan 11 12:12:24 NZDT 2014
Hi Chad,
On Fri, Jan 10, 2014 at 3:02 PM, Chad Roseburg <croseburg at ncrl.org> wrote:
> I'm trying to assess the usage of a particular collection and am wondering
> if the 'issues' field in the items table represents all issues: Ie., both
> from the old_issues and issues tables.
Yes -- items.issues gets incremented every time an item is checked
out, so if all you need is a count, you don't need to include either
the issues or old_issues tables in your query.
Regards,
Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email: gmc at esilibrary.com
direct: +1 770-709-5581
cell: +1 404-984-4366
skype: gmcharlt
web: http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org
More information about the Koha
mailing list