projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT# 83075 - fixed sorting by referrals error
[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
9cd870b
..
ae219c8
100644
(file)
--- a/
FS/FS/cust_main/Search.pm
+++ b/
FS/FS/cust_main/Search.pm
@@
-1115,7
+1115,7
@@
sub search {
# setup queries, subs, etc. for the search
##
# setup queries, subs, etc. for the search
##
- $orderby ||= 'ORDER BY custnum';
+ $orderby ||= 'ORDER BY cust
_main.cust
num';
# here is the agent virtualization
push @where,
# here is the agent virtualization
push @where,
@@
-1213,8
+1213,7
@@
sub search {
}
}
- # set select a customer only once. some joins create multiple customer records.
- my $select = 'DISTINCT ON (cust_main.custnum) ' . join(', ', @select);
+ my $select = join(', ', @select);
my $sql_query = {
'table' => 'cust_main',
my $sql_query = {
'table' => 'cust_main',