diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2019-04-03 10:08:11 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2019-04-03 14:01:41 -0400 |
| commit | 1370d9061f191fa7e62e89e128263f7c128ee8f1 (patch) | |
| tree | 2cc34280776320dda30c4cd3b0c7c1d4a67367b6 | |
| parent | d1379237b5bc4e290fc8255726b736622e51b29f (diff) | |
RT# 83090 - updated customer search to allow multiple orderbys
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index c2620bdfa..091be9956 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -619,7 +619,7 @@ sub search { my $dbh = dbh; my @where = (); - my $orderby; + my $orderby = "ORDER BY cust_main.custnum"; # initialize these to prevent warnings $params = { @@ -909,7 +909,7 @@ sub search { } } - $orderby ||= "ORDER BY cust_main.$field"; + $orderby .= ", cust_main.$field"; } @@ -1120,7 +1120,7 @@ sub search { # setup queries, subs, etc. for the search ## - $orderby ||= 'ORDER BY custnum'; + $orderby ||= 'ORDER BY cust_main.custnum'; # here is the agent virtualization push @where, |