From: Ivan Kohler <ivan@freeside.biz>
Date: Tue, 7 Jun 2016 08:25:40 +0000 (-0700)
Subject: fix customer list/search, RT#41684, RT#20173
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=6d821bf9a2419a177014cf882178370a0cdc748f;hp=a9a0e9deba329f2427082e5c30a308d11118b5e0

fix customer list/search, RT#41684, RT#20173
---

diff --git a/httemplate/search/cust_main.cgi b/httemplate/search/cust_main.cgi
index 76cbe4928..62231a120 100755
--- a/httemplate/search/cust_main.cgi
+++ b/httemplate/search/cust_main.cgi
@@ -129,7 +129,10 @@
 %          'select'      => 'part_svc.*, COUNT(*) AS num_cust_svc',
 %          'table'       => 'part_svc', 
 %          'addl_from'   => 'LEFT JOIN cust_svc USING ( svcpart )',
-%          'extra_sql'   => 'WHERE pkgnum = ? GROUP BY part_svc.svcpart',
+%          'extra_sql'   => 'WHERE pkgnum = ? '.
+%                           ' GROUP BY '. join(', ',
+%                             map "part_svc.$_", fields('part_svc')
+%                           ),
 %          'extra_param' => [ [$cust_pkg->pkgnum,'int'] ],
 %        })
 %      ) {