https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37886 --- Comment #1 from Brendan Lawlor <blawlor@clamsnet.org> --- Created attachment 171288 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=171288&action=edit Bug 37886: Make multiselect parameters optional in SQL reports This bug changes the default starting value for multiselects to be a newline separated list of all authorised values so the SQL in() function does not limit the results when no selections are made. To test: 1. Create an SQL report like select * from items where homebranch in <<Libraries|branches:in>> and itype in <<Item type|itemtypes:in>> 2. Run the report without selecting any parameters 3. Notice no results are returned 4. Click 'Show SQL code' 5. Notice '%' is used for the parameter incorrectly 6. Apply patch and repeat step 2 7. Notice results are returned 8. Click 'Show SQL code' 9. Notice the in() function correctly includes a comma separated list of all authorised values 10. Run the report again with single and multiple selections 11. Confirm the SQL code is generated as expected -- You are receiving this mail because: You are watching all bug changes.