From 781a4348dd3cbe705d6265d36ac5e08b3ed5d01f Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Fri, 31 May 2013 15:36:42 -0700 Subject: [PATCH] service smart search, #23297, fallout from #22385 --- FS/FS/cust_svc.pm | 3 ++- httemplate/search/cust_svc.html | 4 ++-- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm index 627410729..94f04e9b7 100644 --- a/FS/FS/cust_svc.pm +++ b/FS/FS/cust_svc.pm @@ -890,7 +890,8 @@ sub smart_search_param { ( 'table' => 'cust_svc', 'select' => 'svc_all.svcnum AS svcnum, '. - 'COALESCE(svc_all.svcdb, part_svc.svcdb) AS svcdb', + 'COALESCE(svc_all.svcdb, part_svc.svcdb) AS svcdb, '. + 'cust_svc.*', 'addl_from' => $addl_from, 'hashref' => {}, 'extra_sql' => $extra_sql, diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html index b245d3114..6fa93905e 100644 --- a/httemplate/search/cust_svc.html +++ b/httemplate/search/cust_svc.html @@ -47,8 +47,8 @@ die "access denied" my $sql_query; -my $orderby = 'ORDER BY svcnum'; #has to be ordered by something - #for pagination to work +my $orderby = 'ORDER BY cust_svc.svcnum'; #has to be ordered by something + #for pagination to work if ( length( $cgi->param('search_svc') ) ) { -- 2.11.0