https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41911
Bug ID: 41911
Summary: Itemnumber values for certain RENEWAL actions are
wrapped in quotes in the action_logs table
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: trivial
Priority: P5 - low
Component: Tools
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
If an item is renewed from the patron checkouts table on either circulation.pl
or moremember.pl, the associated action_logs info field will wrap the
itemnumber value in quotes. This does not happen for RENEWAL actions made via
the header search and RENEWAL actions taken in the OPAC.
This is especially problematic when joining the items table to action_logs in a
custom report if the quotes aren't accounted for. It also creates malformed
data menu links if itemnumber is extracted from the info column into its own
column in a report.
To see the problem in ktd:
1. Set the RenewalLog syspref to Log
2. Check an item out to a patron
- sample patron: 23529001000463
- sample item: 39999000019179
3. Renew the item in the staff client via the patron's checkouts table at
circulation.pl or moremember.pl
4. Create and run a report on the action logs table:
SELECT action_id, timestamp, user, module, action, object, interface,
json_extract(info,"$.itemnumber") AS itemnumber,
info
FROM action_logs
WHERE module = 'CIRCULATION'
5. Notice the itemnumber value in the info column for the RENEWAL line is
wrapped in quotes, but the value is not wrapped in quotes for the ISSUE line.
6. Note the data menu links in the extracted itemnumber column do not work for
the RENEWAL line but do work for the ISSUE line.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
