diff options
| author | Mark Wells <mark@freeside.biz> | 2013-06-19 12:15:11 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-06-19 12:15:11 -0700 |
| commit | 67e981bedc57f0834bdb43069366e6026c058705 (patch) | |
| tree | f0bada5d4a3362612d19f9f3f19d0fc72068def5 /httemplate | |
| parent | ebb4bf021ce1fa3d3c4fc64d3641452e2f69faeb (diff) | |
make service search by svcdb return the same field set as smart search, #23621, #22385, etc.
Diffstat (limited to 'httemplate')
| -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(), ); |