[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 #3 from Brendan Lawlor <blawlor at clamsnet.org> ---
This is a great idea.

I think the report syntax could be similar to when reports include the all
option.

<<Select branches| branches:in>>

Then if the 'in' parameter is included guided_reports_start.tt would render
that element something like
<select name="sql_params" tabindex="1" id="sql_params_Homebranch" multiple>

so the user could select multiple options.

Then when the report is run the SQL would be somehow generated as a comma
separated list of the options the user selected.


For example:
WHERE branchcode IN (<<Select branches|branches:in>>)
would become
WHERE branchcode IN ('opt1', 'opt2', 'opt3')

I think this bug contains some clues to how to implement this:
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93555&action=diff

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.