From b1d26754480ee77604521236d9cf9952df2d3e12 Mon Sep 17 00:00:00 2001 From: Christopher Burger Date: Wed, 3 Apr 2019 10:08:11 -0400 Subject: [PATCH] RT# 83090 - updated customer search to allow multiple orderbys --- FS/FS/cust_main/Search.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index 9cd870b96..7216fe604 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -618,7 +618,7 @@ sub search { my $dbh = dbh; my @where = (); - my $orderby; + my $orderby = "ORDER BY cust_main.custnum"; # initialize these to prevent warnings $params = { @@ -937,7 +937,7 @@ sub search { } } - $orderby ||= "ORDER BY cust_main.$field"; + $orderby .= ", cust_main.$field"; } @@ -1115,7 +1115,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, -- 2.11.0