diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-12-08 08:55:07 -0500 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-12-08 08:55:07 -0500 |
| commit | f4a0aa6fc746ba02dd021ece8f46b2ca4e001cc4 (patch) | |
| tree | c0629f9798bb6da29ed848237d76f7d87a35f658 | |
| parent | 94a109cdf724aa61b2bddf8636c935c00827d914 (diff) | |
RT# 77532 - search count is now correct
| -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 = ''; |