Bug 33619

Summary: the "update sql" window isn't showing obsolete fields and their new names.
Product: Koha Reporter: Marie-Luce Laflamme <marie-luce.laflamme>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: patrick.robitaille
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Marie-Luce Laflamme 2023-04-26 19:50:44 UTC
The “update sql” button of an obsolete report has stopped describing fields that need to be fixed.

If your report still contains a biblioitems.marcxml field, Koha will warn with a “This report seems obsolete” message. Then, you can click on the “update sql” button to fix the report, and Koha will open up a popup window.

Unfortunately, this window is no longer showing obsolete fields and their new names. Instead, there is only a loading cursor on display without any explanations. 

At this point, you aren't sure if you can click on the "update" button within the window, thinking it may be broken. But if you try, Koha will update the report correctly.

Is there a way to bring back the previous version behaviour in this window?
Comment 1 Marie-Luce Laflamme 2023-04-26 19:54:51 UTC
Test plan
1. Add a report that contains a biblioitems.marcxml field (e.g. ExtractValue(marcxml,'//datafield[@tag="245"]/@ind2')  tinyurl.com/2ky73zhr )
2. Go back to the saved reports page and find the new report /cgi-bin/koha/reports/guided_reports.pl?phase=Use saved
3. Click on "update sql"
--> Koha will open up a popup window that shows an endless loading cursor without any information about what need to be fixed in the report.
Comment 2 Marie-Luce Laflamme 2023-11-20 19:35:32 UTC
I'm not sure how, but this behaviour has disappeared.