[Bug 37886] New: SQL reports - Multiselect parameters should be optional
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37886 Bug ID: 37886 Summary: SQL reports - Multiselect parameters should be optional Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: blawlor@clamsnet.org Reporter: blawlor@clamsnet.org QA Contact: testopia@bugs.koha-community.org Depends on: 37077 When a report is written with multiselect parameters and the the report is run with nothing selected the report results should not be limited. Multiselect reports use the IN() function, so the SQL should be generated with a comma separated list of all of the authorised values. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37077 [Bug 37077] SQL Reports - Picking only one option for each multiple selection results in wrong query -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37886 Brendan Lawlor <blawlor@clamsnet.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Trivial patch Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37886 Brendan Lawlor <blawlor@clamsnet.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |RESOLVED Resolution|--- |DUPLICATE --- Comment #2 from Brendan Lawlor <blawlor@clamsnet.org> --- *** This bug has been marked as a duplicate of bug 37050 *** -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37886 Bug 37886 depends on bug 37077, which changed state. Bug 37077 Summary: SQL Reports - Picking only one option for each multiple selection results in wrong query https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37077 What |Removed |Added ---------------------------------------------------------------------------- Status|Needs documenting |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org