[Koha-bugs] [Bug 9634] Allow for parameters re-use on SQL reports

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

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

M. Tompsett <mtompset at hotmail.com> changed:

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

--- Comment #5 from M. Tompsett <mtompset at hotmail.com> ---
Created attachment 70735
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=70735&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

Signed-off-by: Mark Tompsett <mtompset at hotmail.com>

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