From c0a000d5df14c679753e670b94517cf2e8a756f4 Mon Sep 17 00:00:00 2001 From: Owen Date: Thu, 28 Oct 2021 15:45:21 +0000 Subject: [PATCH] Bug 29328: Add missing list parameter to reports parameter menu This patch adds an option to insert "list" as a runtime parameter in SQL reports (As added by Bug 27380). To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" button and select "List." - Customize the parameter label if you wish and click "Insert parameter." - The parameter should be inserted like this: <> - Use it to create a valid SQL report, for example: SELECT * FROM borrowers WHERE categorycode IN <> LIMIT 10 - Confirm that upon running the report you are shown a textarea. Enter two or more values in the textarea, each on a separate line. - Confirm that the report runs correctly. The SQL above would show you this when you click "Show SQL code": SELECT * FROM borrowers WHERE categorycode IN ('A','S') LIMIT 10 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 e766923601..83a6ec3efb 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 @@ -1550,6 +1550,11 @@ $("#paramLabel").val( _("Patron category") ); $("#param_category").val("categorycode"); break; + case "insertList": + modalTitle.text( _("Insert list parameter") ); + $("#paramLabel").val( _("List of values") ); + $("#param_category").val("list"); + break; case "insertText": modalTitle.text( _("Insert text parameter") ); $("#paramLabel").val( _("Text") ); @@ -2280,6 +2285,7 @@
  • Date
  • Item types
  • Libraries
  • +
  • List
  • Patron categories
  • Text field
  • -- 2.39.5