X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_svc.html;h=a2cdc8a2d3be01deb789ada3577b2e4d5a9ed23f;hb=26b237b61bb5340e92edb033f48371c8e8d2de55;hp=3beca4d83c93cc62ae6dfa005797f327b4f1b0ef;hpb=718f65eee1c797ea90a315b5f03fae75c80a5112;p=freeside.git diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html index 3beca4d83..a2cdc8a2d 100644 --- a/httemplate/search/cust_svc.html +++ b/httemplate/search/cust_svc.html @@ -94,7 +94,9 @@ if ( length( $cgi->param('search_svc') ) ) { } #here is the agent virtualization -push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql; +push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql( + 'null_right' => 'View/link unlinked services' + ); my $extra_sql = ' WHERE '. join(' AND ', @extra_sql ); @@ -108,7 +110,8 @@ my $sql_query = { 'table' => 'cust_svc', 'addl_from' => $addl_from, 'hashref' => {}, - 'extra_sql' => "$extra_sql $orderby", + 'extra_sql' => $extra_sql, + 'order_by' => $orderby, }; my $count_query = "SELECT COUNT(*) FROM cust_svc $addl_from $extra_sql";