[Koha-bugs] [Bug 9634] Allow for parameters re-use on SQL reports
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jan 17 03:41:26 CET 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9634
--- Comment #2 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 70592
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=70592&action=edit
Bug 9634: Allow for combining same paraneters in SQL reports
This patch set adds a new colum to saved_sql 'combine_params'
If set, parameters that have the same name and data type will only be
asked for once from the user
To test:
1 - Create a report that takes multiple parameters, e.g.:
SELECT <<cat>> AS one, <<dog|branches>> AS two, <<dog|YES_NO>> as three,
<<cat>> as four, <<dog|branches>> as five
2 - Run this report, note you are asked for five parameters
3 - Apply patch
4 - Update database
5 - Run report, note you are still asked for five parameters
6 - Edit report, note the 'Combine params' options, say YES!!!!!
7 - Re-run the report, you shoudl be asked for three parameters
8 - Verify the results reflect the supplied parameters
9 - Create a new report (perhaps something more substantive)
10 - Save with 'combine params' checke
11 - View in saved reports and see the new 'combine params' column
12 - Verify it is correctly set
13 - Run the report and verify correct results
14 - prove -v t/db_dependent/Reports/Guided.t
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list