https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37763 Bug ID: 37763 Summary: SQL reports Update and run SQL appends the editor screen after the report results. Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: cj.lynce@westlakelibrary.org QA Contact: testopia@bugs.koha-community.org When editing SQL reports, using 'Update and run SQL' inappropriately includes the SQL editor at the bottom of the run report. Additionally, this issue causes the saved_sql.id to be appended repeated as described in bug_37307. Although there certainly could be some usefulness for SQL developers in having the editor appear under the report when testing, the SQL editing box does not function correctly (no auto population of tables, etc.). This is issues by the CSRF changes made in reports/guided_reports.pl that are causing to 'edit' screen to be appended to the 'run' screen. 1) Login to staff client 2) Navigate to Reports -> Create from SQL 3) Create a short report (SELECT * FROM items), name it and SAVE it. 4) On the resulting "Edit SQL report' page, click 'Update and run SQL' 5) See the report runs, but at the 'Edit SQL report' screen shows at the bottom (it should not) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.