https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35746
--- Comment #6 from Brendan Lawlor <blaw...@clamsnet.org> --- Created attachment 160995 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=160995&action=edit Bug 35746: add multiselect to reports dropdowns This is a work in progress patch to add multiselect to report dropdowns. Test Plan: 1. Create an SQL report with with new syntax for multi select SELECT * FROM branches WHERE branchcode in (<<Select branches|branches:in>>) 2. Save the report 3. Note that you get the error The authorized value category (branches:in) you selected does not exist. 4. Apply patch and repeat steps 1 and 2 5. Note the report saves successfully 6. Run the report 7. Note the select dropdown is now a multiselect 8. Run the report with multiple selections 9. Note that the multiselect choices are in the url like: guided_reports.pl?reports=2&phase=Run+this+report¶m_name=Select+branches%7Cbranches%3Ain&sql_params=CPL&sql_params=FFL&sql_params=FPL 10. Click show SQL and note that only the first parameter gets inserted intot he query like: WHERE branchcode in ('CPL') TODO: Format the multiselected parameterss as a comma separated list to generate valid SQL like: WHERE branch in ('CPL', 'FFL', 'FPL') -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/