[Koha-bugs] [Bug 34051] Koha::AuthorisedValues->get_description_by_koha_field not caching results for non-existent values

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34051

--- Comment #3 from David Cook <dcook at prosentient.com.au> ---
Test plan:

0. Apply patch and koha-plack --restart kohadev
1. Go to create a SQL report from SQL
/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL
2. Save a report with the following SQL:
SELECT barcode FROM items where barcode <> '';
3. Run the report
4. Download as CSV
5. Edit the CSV and remove the "barcode" heading

6. Go to edit item for barcode 3999900000001
/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=1&itemnumber=1
7. Add "Damaged status" of "Damaged"
8. Click "Save changes"

9. koha-mysql kohadev
10. update items set notforloan = 9 where barcode = 3999900000001;

11. Go to inventory tool
http://localhost:8081/cgi-bin/koha/tools/inventory.pl
12. Upload barcode file via "Choose file"
13. Uncheck "Compare barcodes list to results"
14. Open F12 tools
15. Click "Submit"
16. Click "OK" on confirm box

17. Note that the inventory job takes around 30 seconds to run
instead of 50 seconds
17b. The exact figures may vary. If you compare with before patch
inventory runs, you'll be saving roughly 20 seconds.
18. Note that "Damaged" appears in the "Damaged" column, which
demonstrates that the authorized value lookup was completed for
the item in the result list
19. Note that "9" appears in the "Not for loan" column, and
"0" appears in the "Lost" and "Withdrawn" columns, which demonstrates
that the authorized value lookup wasn't able to find descriptions for
these codes.

-- 
You are receiving this mail because:
You are watching all bug changes.