https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29328 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add "list" to parameter |Add missing list parameter |dropdown |to reports parameter menu Severity|enhancement |normal Assignee|koha-bugs@lists.koha-commun |oleonard@myacpl.org |ity.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29328 --- Comment #1 from Owen Leonard <oleonard@myacpl.org> --- Created attachment 127065 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127065&action=edit Bug 29328: Add missing list parameter to reports parameter menu This patch adds an option to insert "list" as a runtime parameter in SQL reports (As added by Bug 27380). To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" button and select "List." - Customize the parameter label if you wish and click "Insert parameter." - The parameter should be inserted like this: <<List of values|list>> - Use it to create a valid SQL report, for example: SELECT * FROM borrowers WHERE categorycode IN <<List of values|list>> LIMIT 10 - Confirm that upon running the report you are shown a textarea. Enter two or more values in the textarea, each on a separate line. - Confirm that the report runs correctly. The SQL above would show you this when you click "Show SQL code": SELECT * FROM borrowers WHERE categorycode IN ('A','S') LIMIT 10 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29328 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #127065|0 |1 is obsolete| | --- Comment #2 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- Created attachment 127068 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127068&action=edit Bug 29328: Add missing list parameter to reports parameter menu This patch adds an option to insert "list" as a runtime parameter in SQL reports (As added by Bug 27380). To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" button and select "List." - Customize the parameter label if you wish and click "Insert parameter." - The parameter should be inserted like this: <<List of values|list>> - Use it to create a valid SQL report, for example: SELECT * FROM borrowers WHERE categorycode IN <<List of values|list>> LIMIT 10 - Confirm that upon running the report you are shown a textarea. Enter two or more values in the textarea, each on a separate line. - Confirm that the report runs correctly. The SQL above would show you this when you click "Show SQL code": SELECT * FROM borrowers WHERE categorycode IN ('A','S') LIMIT 10 Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29328 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #127068|0 |1 is obsolete| | --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 127119 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127119&action=edit Bug 29328: Add missing list parameter to reports parameter menu This patch adds an option to insert "list" as a runtime parameter in SQL reports (As added by Bug 27380). To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" button and select "List." - Customize the parameter label if you wish and click "Insert parameter." - The parameter should be inserted like this: <<List of values|list>> - Use it to create a valid SQL report, for example: SELECT * FROM borrowers WHERE categorycode IN <<List of values|list>> LIMIT 10 - Confirm that upon running the report you are shown a textarea. Enter two or more values in the textarea, each on a separate line. - Confirm that the report runs correctly. The SQL above would show you this when you click "Show SQL code": SELECT * FROM borrowers WHERE categorycode IN ('A','S') LIMIT 10 Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29328 --- Comment #4 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Pushed to master for 21.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29328 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m --- Comment #6 from Fridolin Somers <fridolin.somers@biblibre.com> --- Depends on Bug 27380 not in 20.11.x -- You are receiving this mail because: You are watching all bug changes.