Bug 35712

Summary: Make clear in historical data when a checkout fills a hold
Product: Koha Reporter: Andrew Fuerste-Henry <andrew>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: kebliss, mspinney, nick, sspohn
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Andrew Fuerste-Henry 2024-01-05 14:50:19 UTC
There is not currently a direct data linkage between a filled hold in old_reserves and the checkout that filled it in (old_)issues. It'd be helpful if we could put the issue_id into the old_reserves table to make that explicit.
Comment 1 Steve, OSLRI, USA 2024-11-12 14:10:34 UTC
On a similar note, it would be helpful to add issue_id and reserves_id to the statistics table.  (I've found the timestamps across statistics, issues, reserves and action_logs don't match up neatly.)
Comment 2 Andrew Fuerste-Henry 2025-09-04 12:42:20 UTC
(In reply to Steve, OSLRI, USA from comment #1)
> On a similar note, it would be helpful to add issue_id and reserves_id to
> the statistics table.  (I've found the timestamps across statistics, issues,
> reserves and action_logs don't match up neatly.)

And to the pseudonymized_transactions table, too.