[Bug 43868] New: Log viewer search does not find circulation entries by item barcode
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 Bug ID: 43868 Summary: Log viewer search does not find circulation entries by item barcode Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: slavashishkin@gmail.com QA Contact: testopia@bugs.koha-community.org Depends on: 29016 Target Milestone: --- Searching the log entries table by item barcode returns no matches, even when the barcode is visible in the Info column of a circulation entry. Reproduced on current community main, with bugs 29016 and 43119 already applied. To reproduce: 1. Open a patron's modification log containing a checkout or check-in entry with a visible item barcode. 2. Copy the barcode into the table's Search box. 3. Observe that no matching records are found. 4. Search by the item's internal itemnumber. 5. Observe that the entry is found. Expected: Searching by the displayed item barcode finds the matching circulation entries. Actual: Searching by barcode returns no matches, while searching by itemnumber finds the entries. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29016 [Bug 29016] Improve performance of the Log viewer when working with a high volume of action logs -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 --- Comment #1 from Slava Shishkin <slavashishkin@gmail.com> --- Created attachment 208608 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=208608&action=edit Bug 43868: Restore barcode search in circulation logs The log viewer displays item barcodes using embedded item data, but server-side searching only checks the original action log fields. Add a database relationship resolving circulation items from JSON or legacy itemnumber values in info. Include the related barcode in the Info column search while retaining server-side pagination. Test plan: Before applying the patch: 1. Open a patron's modification log containing checkout or check-in entries with a visible item barcode. 2. Search the table using that barcode. 3. Confirm that no matching records are found. 4. Search by the item's internal itemnumber. 5. Confirm that the entries are found. After applying the patch: 1. Restart Plack and reload the page. 2. Repeat the full barcode search. 3. Confirm that the matching entries are found. 4. Search using part of the barcode and confirm that they are found. 5. Confirm that searching by itemnumber still works. 6. Clear the search and confirm that all original entries return. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 Slava Shishkin <slavashishkin@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 Slava Shishkin <slavashishkin@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |slavashishkin@gmail.com |ity.org | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #208608|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 --- Comment #2 from Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de> --- Created attachment 208614 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=208614&action=edit Bug 43868: Restore barcode search in circulation logs The log viewer displays item barcodes using embedded item data, but server-side searching only checks the original action log fields. Add a database relationship resolving circulation items from JSON or legacy itemnumber values in info. Include the related barcode in the Info column search while retaining server-side pagination. Test plan: Before applying the patch: 1. Open a patron's modification log containing checkout or check-in entries with a visible item barcode. 2. Search the table using that barcode. 3. Confirm that no matching records are found. 4. Search by the item's internal itemnumber. 5. Confirm that the entries are found. After applying the patch: 1. Restart Plack and reload the page. 2. Repeat the full barcode search. 3. Confirm that the matching entries are found. 4. Search using part of the barcode and confirm that they are found. 5. Confirm that searching by itemnumber still works. 6. Clear the search and confirm that all original entries return. Signed-off-by: Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off --- Comment #3 from Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de> --- Signed off using a sandbox -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43868 Lisette Scheer <lisette@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact|testopia@bugs.koha-communit |lisette@bywatersolutions.co |y.org |m -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org