Bug 10680

Summary: "Modification log" gives wrong data
Product: Koha Reporter: Kyle M Hall <kyle>
Component: Transaction logsAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: major    
Priority: P3 CC: jonathan.druart, katrin.fischer, kyle, mioara_v18, severine.queune
Version: unspecified   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10352
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12235
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14444
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 22794    

Description Kyle M Hall 2013-08-02 19:29:49 UTC
When viewing a record, the "Modification log" tab on the left hand side should display the modifications for that biblionumber, but instead it will pull the modifications for the itemnumber instead.

That is, if the record you are viewing has a biblionumber of 42, and you follow the "Modification log" link, you will be seeing the modifications for the item whose itemnumber is 42 instead!
Comment 1 Kyle M Hall 2013-08-02 19:36:59 UTC
One issue is that the biblionumber is not stored in the log for cataloging modifications, so the only way to get the list of modifications by biblionumber is to select where "object IN ( SELECT itemnumber FROM items UNION deleteditems WHERE biblionumber = ?".

So, basically we need a special case in GetLogs for modules=CATALOGUING and action=MODIFY.
Comment 2 Kyle M Hall 2013-08-02 19:42:44 UTC
Or, I think the correct answer is to update the object to the biblionumber for  modules=CATALOGUING and action=MODIFY, as we can never view the specific item logs from a link in the intranet. If we do this, we can pull modification both via biblionumber ( via object ) and itemnumber ( via searching the info field with "'itemnumber' => '63661'".

It's really a bit of a mess, as 'object' is used for biblionumber in some circumstances, and as itemnumber in others ( biblio vs item edit ) yet there is no way to specify what you are looking for at that level. There is no way to know if you are asking for biblio edits or item edits.

The only sensible way to solve this to me is to make 'object' always be biblionumber.
Comment 3 Katrin Fischer 2013-08-17 09:20:57 UTC
Hi Kyle, I have run into this a while ago I think and left some confused notes on bug 10352.
Comment 4 Mioara Voncila 2019-01-08 10:50:01 UTC
On a Log View search on the CATALOG Module, with MODIFY action, by entering the "biblio" option in the "object" field, there is no result.
Comment 5 Jonathan Druart 2019-05-30 02:40:25 UTC

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