[Koha-bugs] [Bug 1750] Report bor_issues_top erroneous and truncated results.
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Apr 1 05:53:06 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1750
--- Comment #7 from M. Tompsett <mtompset at hotmail.com> ---
Comment on attachment 49762
--> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=49762
Bug 1750 - Report bor_issues_top erroneous and truncated results.
Review of attachment 49762:
--> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=1750&attachment=49762)
-----------------------------------------------------------------
::: reports/bor_issues_top.pl
@@ +279,4 @@
> my $strcalc ;
>
> # Processing average loanperiods
> + $strcalc .= "SELECT CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname), COUNT(*) AS RANK, borrowers.borrowernumber AS ID";
http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_concat-ws
Nice! CONCAT_WS skips NULL entries, but still concat's, while CONCAT gives up
and returns NULL.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list