Bug 32439

Summary:	Allow selective deletion of statistics entries based on type by cleanup_database
Product:	Koha	Reporter:	Andrew Fuerste-Henry <andrew>
Component:	Command-line Utilities	Assignee:	Bugs List <koha-bugs>
Status:	RESOLVED DUPLICATE	QA Contact:	Testopia <testopia>
Severity:	enhancement
Priority:	P5 - low	CC:	robin
Version:	Main
Hardware:	All
OS:	All
Change sponsored?:	---	Patch complexity:	---
Documentation contact:		Documentation submission:
Text to go in the release notes:		Version(s) released in:
Circulation function:
Bug Depends on:	19008, 24151
Bug Blocks:

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 ***