The new List parameter isn't included in the new Insert Parameter dropdown. It should be.
Created attachment 127065 [details] [review] 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
Created attachment 127068 [details] [review] 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>
Created attachment 127119 [details] [review] 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>
Pushed to master for 21.11, thanks to everybody involved!
Pushed to 21.05.x for 21.05.05
Depends on Bug 27380 not in 20.11.x