[Koha] Reports returning different totals

[Chris Cormack]

On 6 May 2011 06:59, Cindy Weber <cweber at scls.lib.wi.us> wrote:
> Thank you for the explanation!  Between your explanation and Beverly
> Church's I've managed to figure out the problem.  The top report listed
> the checkouts by the home library of the patron, not the checkout
> library so that was part of the issue.  The other is we do appear to be
> affected by the reporting bug as well.  There are thousands of renewals
> that show as having no agency code so they weren't included in the
> second report totals.
>
> Is there someplace else to get the renewal information?  I would think
> issues.lastrenewdate and old_issues.lastrenewdate would get me some of
> them but not if the item had been renewed twice.
>
Hi Cindy

The renewal information in the statistics table is more complete than
using the lastrenewate, all it is missing is the branch info. So I
would follow Owens suggestion for amending the report so it does a
left join and groups the renewals together under a null branch code.

If I remember correctly, the bug with renewals is limited only to
those renewed from the OPAC, and the sticking point for the fix is
what branch to store, since they aren't really renewing them from
anywhere. I think the consensus was to use the borrowers homebranch.

If people think this is a good enough fix, I could do a patch to get
that being stored and submit it for sign off today. I'm assuming the
PTFS fork pulls in code from actual Koha from time to time? If so,
they should be able to apply that fix there too.

Chris