RT# 77532 - search count is now correct
authorChristopher Burger <burgerc@freeside.biz>
Sat, 8 Dec 2018 13:55:07 +0000 (08:55 -0500)
committerChristopher Burger <burgerc@freeside.biz>
Sat, 8 Dec 2018 14:16:47 +0000 (09:16 -0500)
Conflicts:
FS/FS/cust_main/Search.pm

FS/FS/cust_main/Search.pm

index b1af41c..3061b2c 100644 (file)
@@ -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'}) {