Bug 29767: SQL Koha reports and variable of database table << name|table_name>>
authorjeremy breuillard <jeremy.breuillard@biblibre.com>
Wed, 22 Dec 2021 10:42:07 +0000 (11:42 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 10 Feb 2022 08:01:37 +0000 (22:01 -1000)
commit5ce1048cba8c601434ed409f26d0d335365469ae
treee905a9e4e1be3de8adf918c7c637677881d28aa2
parentb78395d8fec361fcc336864bd2482cce7b0aeacd
Bug 29767: SQL Koha reports and variable of database table << name|table_name>>

'Insert runtime parameter' has now more options for the SQL reports : 'cash register', 'debit types' and 'credit types'

Test plan:
1)Home > Reports > Create from SQL
2)Click on 'Insert runtime parameter' and notice the current options
3)Apply patch and repeat 2)
4)New parameters are now available
5)A simple SQL request to try 'credit_types' option : SELECT * FROM account_credit_types WHERE code = <<Credit types|credit_types>>

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
https://bugs.koha-community.org/show_bug.cgi?id=29796
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
C4/Reports/Guided.pm
koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt
reports/guided_reports.pl
t/db_dependent/Reports/Guided.t