From 6d821bf9a2419a177014cf882178370a0cdc748f Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Tue, 7 Jun 2016 01:25:40 -0700 Subject: [PATCH] fix customer list/search, RT#41684, RT#20173 --- httemplate/search/cust_main.cgi | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) 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'] ], % }) % ) { -- 2.11.0