@@ -, +, @@ menu - 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 --- .../prog/en/modules/reports/guided_reports_start.tt | 6 ++++++ 1 file changed, 6 insertions(+) --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ a/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
  • --