[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.


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 &

More information about the Koha mailing list