[Koha-bugs] [Bug 23838] Add ability to view item renew history

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23838

--- Comment #45 from Andrew Isherwood <andrew.isherwood at ptfs-europe.com> ---
Hi Katrin

(Looks like I was typing my message below at the same time you were typing
yours, I think we came to the same conclusion)

The more I look at this, the more it feels like it's a major undertaking which
is way bigger than my original development.

I had not appreciated that a renewal isn't currently separately recorded,
instead the original issue is just updated with a renewed date and renewal
count. In order to achieve the sort of thing you described above Tomás, I'll
need to change to recording a new row in the issues table for each renewal,
which I'm sure will have implications in many places.

This seems to me to be a fundamental, and very significant, change in the way
renewals are recorded and I must confess I am not at all confident of being
able to achieve it without substantial regressions.

A less impactful approach may be to retain the current behaviour of modifying
the original issue, but also store details of each renewal in a separate
"renewals" table. I appreciate that this is basically the same approach as
storing in action_logs, but in a less volatile location. It would also make all
the renewal related columns in the issues table effectively redundant, but it
would allow a incremental approach with minimal potential regressions. The
redundant columns in issues could be migrated as a separate bug.

In fact, it feels like the change detailed above should be carried out as a bug
separate to this one first, which this bug is then dependent on.

What I've said above is probably naive and full of holes, but it would be good
to come up with an approach that's not going to introduce and tonne of
regressions and will allow me to achieve what I'm aiming for.

-- 
You are receiving this mail because:
You are watching all bug changes.