[Koha-bugs] [Bug 35746] Multiple selections for parameters used in the IN function

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35746

--- Comment #6 from Brendan Lawlor <blawlor at 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&param_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.