[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

Biblibre Sandboxes <sandboxes at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #161247|0                           |1
        is obsolete|                            |

--- Comment #11 from Biblibre Sandboxes <sandboxes at biblibre.com> ---
Created attachment 161248
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=161248&action=edit
Bug 35746: Add multiselect to report dropdowns

This work in progress patch adds the ability to use multi select in report
dropdowns.

It uses syntax similar to using a list and when using the :all option
WHERE i.homebranch in <<Select libraries|brnaches:in>>

Currently this works but fails qa scripts because of some forbidden regex

Test plan:
1. Create an SQL report with with new syntax for multi select
    SELECT
    i.homebranch,
    count(*)
    FROM items i
    WHERE i.homebranch in <<<<Select libraries|brnaches:in>>
    GROUP BY i.homebranch
2. Save the report
3. Note that you get the error
    The authorized value category (branches:in) you selected does not exist.
4. Apply the 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
10. Click show SQL and note that multi select parameters get inserted into the
query like:
     WHERE i.homebranch in ('CPL', 'FFL', 'FPL')
11. Test other types of queries with multiple multi selects and lists etc

Signed-off-by: Andrew Fuerste-Henry <andrewfh at dubcolib.org>

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