Bugzilla – Attachment 49758 Details for
Bug 1750
Report bor_issues_top erroneous and truncated results
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 1750 - Report bor_issues_top erroneous and truncated results.
Bug-1750---Report-borissuestop-erroneous-and-trunc.patch (text/plain), 1.02 KB, created by
Mason James
on 2016-04-01 02:26:34 UTC
(
hide
)
Description:
Bug 1750 - Report bor_issues_top erroneous and truncated results.
Filename:
MIME Type:
Creator:
Mason James
Created:
2016-04-01 02:26:34 UTC
Size:
1.02 KB
patch
obsolete
>From 9ad84020d2e91f6542f89cc9def867fe9ed65b48 Mon Sep 17 00:00:00 2001 >From: Mason James <mtj@kohaaloha.com> >Date: Fri, 1 Apr 2016 15:23:22 +1300 >Subject: [PATCH] Bug 1750 - Report bor_issues_top erroneous and truncated > results. >Content-Type: text/plain; charset="utf-8" > >--- > reports/bor_issues_top.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/reports/bor_issues_top.pl b/reports/bor_issues_top.pl >index b158b7b..30b95b7 100755 >--- a/reports/bor_issues_top.pl >+++ b/reports/bor_issues_top.pl >@@ -279,7 +279,7 @@ sub calculate { > my $strcalc ; > > # Processing average loanperiods >- $strcalc .= "SELECT CONCAT(borrowers.surname , \",\\t\",borrowers.firstname), COUNT(*) AS RANK, borrowers.borrowernumber AS ID"; >+ $strcalc .= "SELECT CONCAT_WS(' ', borrowers.surname , borrowers.firstname), COUNT(*) AS RANK, borrowers.borrowernumber AS ID"; > $strcalc .= " , $colfield " if ($colfield); > $strcalc .= " FROM `old_issues` > LEFT JOIN borrowers USING(borrowernumber) >-- >2.1.4
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 1750
:
49758
|
49759
|
49762
|
49763
|
49820