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:16:47 -0500 |
| commit | 656df6e610807dea9e2c58bd33f763e0e22f8cdc (patch) | |
| tree | f78498c46d1a23db35a50b4618990f8b945f1881 | |
| parent | 1e88509da1f9e4cc1626f1714f64953f9efba8e3 (diff) | |
RT# 77532 - search count is now correct
Conflicts:
FS/FS/cust_main/Search.pm
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index b1af41c2a..3061b2c12 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -1143,7 +1143,7 @@ sub search { } - my $count_query = "SELECT COUNT(*) FROM cust_main $addl_from $extra_sql"; + my $count_query = "SELECT COUNT(DISTINCT cust_main.custnum) FROM cust_main $addl_from $extra_sql"; if ($params->{'flattened_pkgs'}) { |