Bugzilla – Attachment 127065 Details for
Bug 29328
Add missing list parameter to reports parameter menu
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 29328: Add missing list parameter to reports parameter menu
Bug-29328-Add-missing-list-parameter-to-reports-pa.patch (text/plain), 2.62 KB, created by
Owen Leonard
on 2021-10-28 16:02:17 UTC
(
hide
)
Description:
Bug 29328: Add missing list parameter to reports parameter menu
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2021-10-28 16:02:17 UTC
Size:
2.62 KB
patch
obsolete
>From 612dba660eb3b8a0c78c47722dd4505bc519773c Mon Sep 17 00:00:00 2001 >From: Owen <oleonard@myacpl.org> >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: > > <<List of values|list>> > >- Use it to create a valid SQL report, for example: > > SELECT * FROM borrowers WHERE categorycode IN <<List of values|list>> > 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(+) > >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 8b1ed4f447..2fd6ca0aa7 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 >@@ -1551,6 +1551,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") ); >@@ -2282,6 +2287,7 @@ > <li><a href="#" class="insertParam" id="insertDate">Date</a></li> > <li><a href="#" class="insertParam" id="insertItemtypes">Item types</a></li> > <li><a href="#" class="insertParam" id="insertBranches">Libraries</a></li> >+ <li><a href="#" class="insertParam" id="insertList">List</a></li> > <li><a href="#" class="insertParam" id="insertCategorycode">Patron categories</a></li> > <li><a href="#" class="insertParam" id="insertText">Text field</a></li> > </ul> >-- >2.20.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 29328
:
127065
|
127068
|
127119