diff options
| author | Mark Wells <mark@freeside.biz> | 2013-06-19 10:24:28 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-06-19 10:24:28 -0700 |
| commit | 8a796c9b7e9f69c154bf71c90796fa40d89e5527 (patch) | |
| tree | 8865966dc1a650f115a8ba816e523a57492efe71 | |
| parent | d4a8a4dde783d8b106e6ad423655bb5d48232960 (diff) | |
make service search by svcdb return the same field set as smart search, #23621, #22385, etc.
| -rw-r--r-- | httemplate/search/cust_svc.html | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html index 8f10a9495..3b770432e 100644 --- a/httemplate/search/cust_svc.html +++ b/httemplate/search/cust_svc.html @@ -96,8 +96,7 @@ if ( length( $cgi->param('search_svc') ) ) { my $extra_sql = ' WHERE '. join(' AND ', @extra_sql ); $sql_query = { - #'select' => 'svcnum', - 'select' => 'cust_svc.*', + 'select' => 'cust_svc.*, part_svc.*', 'table' => 'cust_svc', 'addl_from' => $addl_from, 'hashref' => {}, @@ -106,9 +105,10 @@ if ( length( $cgi->param('search_svc') ) ) { } +# at this point the query must provide all fields from +# cust_svc and part_svc, and must include join_cust_main. $sql_query->{'select'} = join(', ', $sql_query->{'select'}, - #'part_svc.*', 'cust_main.custnum', FS::UI::Web::cust_sql_fields(), ); |