https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37307
Bug ID: 37307
Summary: Update And Run SQL function appends report ID to
savedsql
Change sponsored?: ---
Product: Koha
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Reports
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Use of the Update And Run SQL button causes koha to append the report ID to the
end of the query. It's commented out, so it doesn't break the query, but it's
adding useless characters.
To recreate:
- save and run this report:
SELECT id, savedsql
FROM saved_sql
WHERE savedsql like "%saved_sql.id: %"
- see your report returns itself
- click Edit
- click Update and Run SQL without changing anything in your report
- click Update and Run SQL again
- look at your report results, notice that the saved query is now repeating "/*
saved_sql.id: 1334 */" at the end
--
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/