[Koha] Circ stats of deleted items

[Eric Phetteplace]

Hi Christopher,

It depends on how your report is written, you want to be sure to be pulling
numbers from both the deleted* database tables as well as the current
(existing item) ones. This generally involves doing a UNION between the
items and deleteditems tables, for instance. There are lots of great
examples on how to accomplish this in the reports library, e.g. see this
one:

https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Circulation_by_Location

Hope that helps!

Best,
Eric Phetteplace
Systems Librarian
California College of the Arts
libraries.cca.edu | vault.cca.edu
510.594.3660
2>/dev/null

On Thu, Jan 26, 2017 at 2:55 PM, Christopher Davis <cgdavis at uintah.utah.gov>
wrote:

> Dear Colleagues,
>
> Will someone please remind me if the circulation statistics of an item
> are included in something like a year-end report if the item was
> deleted from Koha before the report was run. My institution's
> circulation numbers are down this year and we're attempting to
> discover why.
>
> TIA,
>
> Christopher Davis, MLS
> Systems & E-Services Librarian
> Uintah County Library
> cgdavis at uintah.utah.gov
> (435) 789-0091 ext.261
> uintahlibrary.org
> basinlibraries.org
> facebook.com/uintahcountylibrary
> instagram.com/uintahcountylibrary
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>