From d14c1f15a472712d1228906bc0998b82f981d97b Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Thu, 28 Oct 2021 11:00:29 +0000 Subject: [PATCH] Bug 29201: Add option to insert biblio_framework runtime parameter in SQL report This patch modifies the SQL report creation process so that the list of runtime parameters includes an option for bibliographic framework. To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" menu button and select "Bibliographic framework." - You should be shown a modal dialog in which you can change the label on the framework input. - Click "Insert parameter." The SQL field should now contain the correct parameter, e.g. <> - Use the parameter to define an SQL query, e.g. "SELECT * FROM biblio WHERE frameworkcode = <> LIMIT 10" - Run the report. You should be asked to choose a framework. Confirm that the report runs correctly. Signed-off-by: Andrew Fuerste-Henry Signed-off-by: Katrin Fischer Signed-off-by: Jonathan Druart --- .../prog/en/modules/reports/guided_reports_start.tt | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt index 6f26d2c20b..46e2bd4e07 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt @@ -1536,6 +1536,11 @@ $("#paramLabel").val( _("Source of classification or shelving scheme") ); $("#param_category").val("cn_source"); break; + case "insertFramework": + modalTitle.text( _("Insert bibliographic framework parameter") ); + $("#paramLabel").val( _("Framework") ); + $("#param_category").val("biblio_framework"); + break; case "insertDate": modalTitle.text( _("Insert date parameter") ); $("#paramLabel").val( _("Date") ); @@ -2289,6 +2294,7 @@