diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-06-07 01:25:43 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-06-07 01:25:43 -0700 |
| commit | 0d99014e30c82066319e6245101609df7ca63c7d (patch) | |
| tree | 7aeffbfc0d623c899c2680dcf079253f7b3e8405 /httemplate | |
| parent | 00f903db5078b4137495a3fb6b650890ce92fb5c (diff) | |
fix customer list/search, RT#41684, RT#20173
Diffstat (limited to 'httemplate')
| -rwxr-xr-x | httemplate/search/cust_main.cgi | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/httemplate/search/cust_main.cgi b/httemplate/search/cust_main.cgi index aa8c079e1..a3a7aef6b 100755 --- 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'] ], % }) % ) { |