Bug 32440

Summary: Allow selective deletion of statistics entries based on type by cleanup_database
Product: Koha Reporter: Andrew Fuerste-Henry <andrewfh>
Component: Command-line UtilitiesAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: mathsabypro, robin
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32438
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 19008, 24151    
Bug Blocks:    

Description Andrew Fuerste-Henry 2022-12-09 17:50:40 UTC
Cleanup_database can delete all statistics entries more than X days old. If one is using pseudonymization to create pseudonymized_transactions data, then one may wish to use that cleanup_database function to delete statistics entries that have been duplicated in pseudonymized_transactions. However, not all types of transactions in statistics are duplicated in pseudonymized transactions. Statistics includes checkouts, returns, renewals, payments, writeoffs, and localuse. Pseudonymized_transactions only includes checkouts, returns, and renewals.

It would be helpful to be able to delete only statistics entries more than X days old and in a specified list of types.

Approaching this from the other end, Bug 32438 suggests adding payments and writeoffs to pseudonymized_transactions.
Comment 1 Andrew Fuerste-Henry 2022-12-09 17:51:46 UTC
*** Bug 32439 has been marked as a duplicate of this bug. ***