diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-12-08 08:55:07 -0500 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-12-08 09:25:09 -0500 |
| commit | 72cbcafac03e83c15adebac5974cf5322cfcb488 (patch) | |
| tree | a2b098d1fc4f4838d65e0e52d5ee8b4c2822ec54 /FS/FS/cust_main | |
| parent | 8b6dc4bcaa7bed02698627e9f650e305d7c7ae69 (diff) | |
RT# 77532 - search count is now correct
Diffstat (limited to 'FS/FS/cust_main')
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index 3e77704..26f6f03 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -1086,8 +1086,6 @@ sub search { # (maybe we should be using FS::UI::Web::join_cust_main instead?) $addl_from .= ' LEFT JOIN (select refnum, referral from part_referral) AS part_referral_x ON (cust_main.refnum = part_referral_x.refnum) '; - my $count_query = "SELECT COUNT(*) FROM cust_main $addl_from $extra_sql"; - my @select = ( 'cust_main.custnum', 'cust_main.salesnum', @@ -1140,6 +1138,8 @@ sub search { } + my $count_query = "SELECT COUNT(DISTINCT cust_main.custnum) FROM cust_main $addl_from $extra_sql"; + if ($params->{'flattened_pkgs'}) { #my $pkg_join = ''; |