Bug 20096 - Regarding duplicate data in statistics and logs data
Summary: Regarding duplicate data in statistics and logs data
Status: CLOSED WONTFIX
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:
Blocks:
 
Reported: 2018-01-28 05:50 UTC by Kumar
Modified: 2024-07-04 20:38 UTC (History)
3 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 Kumar 2018-01-28 05:50:59 UTC 
Hi

I noticed that there is duplicate data in statistics table and logs table with respect to check-in check out and renewal.

If a user id (staff id or patron id if renewal done online) is added to statistics table there is no need to create a log for transactions. 

Hope this will help remove duplicate data if implemented.
Comment 1 Katrin Fischer 2018-01-30 07:13:42 UTC 
Hi, thx for filing!
Comment 2 Katrin Fischer 2018-02-01 07:02:25 UTC 
I can't think of a reason, why we duplicate the entries in 2 tables like that. We could certainly think about adding the user who did the transaction to statistics as well. I think removing one or the other would be harder as people are relying on both tables for their statistical reports.
Comment 3 Katrin Fischer 2023-10-01 20:21:20 UTC 
I think this is 'too late' to be fixed. People do reporting on both tables and it doesn't hurt to have both.