Bug 32441 - Localuse is recorded in statistics but not recreated in pseudonymized_transactions
Summary: Localuse is recorded in statistics but not recreated in pseudonymized_transac...
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (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 18:00 UTC by Andrew Fuerste-Henry
Modified: 2022-12-09 18:00 UTC (History)
2 users (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 18:00:23 UTC 
The pseudonymization feature creates a parallel to the statistics table without identifiable patron data. This allows one to then use cleanup_database to delete old entries in statistics to remove that patron data.

However, the statistics table also contains records of local use. That data only exists in statistics. It is not duplicated in pseudonymized_transactions, and so is lost if statistics are deleted using cleanup_database.

Bug 32440 suggests teaching cleanup_database to not delete localuse entries.

This bug suggests putting localuse entries into pseudonymized_transactions, even though no patron is involved. That's a bit illogical, but has the benefit of keeping all of this data together.

Meanwhile, Bug 16122 suggesting keeping a local use count in the item record. That would alleviate this issue somewhat, but specific transactional data would be preferable to a running count.