X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_svc.html;h=a2cdc8a2d3be01deb789ada3577b2e4d5a9ed23f;hb=91fd4ea0e91ee9e6717e0b12e01eebb8f8b21322;hp=3beca4d83c93cc62ae6dfa005797f327b4f1b0ef;hpb=40a7b3dc653e099f7bd0bd762b649b04c4432db2;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";