projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
00f903d
)
fix customer list/search, RT#41684, RT#20173
author
Ivan Kohler
<ivan@freeside.biz>
Tue, 7 Jun 2016 08:25:43 +0000
(
01:25
-0700)
committer
Ivan Kohler
<ivan@freeside.biz>
Tue, 7 Jun 2016 08:25:43 +0000
(
01:25
-0700)
httemplate/search/cust_main.cgi
patch
|
blob
|
history
diff --git
a/httemplate/search/cust_main.cgi
b/httemplate/search/cust_main.cgi
index
aa8c079
..
a3a7aef
100755
(executable)
--- a/
httemplate/search/cust_main.cgi
+++ b/
httemplate/search/cust_main.cgi
@@
-128,7
+128,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'] ],
% })
% ) {