diff options
| author | Mark Wells <mark@freeside.biz> | 2013-05-31 15:36:42 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-05-31 15:36:42 -0700 |
| commit | 781a4348dd3cbe705d6265d36ac5e08b3ed5d01f (patch) | |
| tree | 4db2419bd439cbb9e0010e3fca04f14eb342439a | |
| parent | 54a78752a0fc9a82c82dacd111289e886cca6532 (diff) | |
service smart search, #23297, fallout from #22385
| -rw-r--r-- | FS/FS/cust_svc.pm | 3 | ||||
| -rw-r--r-- | 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') ) ) { |