projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT#71513: Card tokenization in v4+
[freeside.git]
/
FS
/
FS
/
cust_main
/
Search.pm
diff --git
a/FS/FS/cust_main/Search.pm
b/FS/FS/cust_main/Search.pm
index
8e6d185
..
11a106a
100644
(file)
--- a/
FS/FS/cust_main/Search.pm
+++ b/
FS/FS/cust_main/Search.pm
@@
-1015,7
+1015,7
@@
sub search {
# always make referral available in results
# (maybe we should be using FS::UI::Web::join_cust_main instead?)
# always make referral available in results
# (maybe we should be using FS::UI::Web::join_cust_main instead?)
- $addl_from .= ' LEFT JOIN
part_referral ON (cust_main.refnum = part_referral
.refnum) ';
+ $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 $count_query = "SELECT COUNT(*) FROM cust_main $addl_from $extra_sql";