Bug 32439 - Allow selective deletion of statistics entries based on type by cleanup_database
Summary: Allow selective deletion of statistics entries based on type by cleanup_database
Status: RESOLVED DUPLICATE of bug 32440
Alias: None
Product: Koha
Classification: Unclassified
Component: Command-line Utilities (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 19008 24151
Blocks:
  Show dependency tree / graph
 
Reported: 2022-12-09 17:50 UTC by Andrew Fuerste-Henry
Modified: 2022-12-09 17:51 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew Fuerste-Henry 2022-12-09 17:50:21 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 

*** This bug has been marked as a duplicate of bug 32440 ***