X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_www.cgi;h=adc31c88aad021181e50518949ac1b44e234d4e5;hb=a6fcaaaeb031cfc5d4a32e75356208f1df965cb2;hp=d3b0549c47e3547f5b1372399dbd362f62d0cbcc;hpb=590603ecaea3184f64530755a76626be8205da49;p=freeside.git

diff --git a/httemplate/search/svc_www.cgi b/httemplate/search/svc_www.cgi
index d3b0549c4..adc31c88a 100755
--- a/httemplate/search/svc_www.cgi
+++ b/httemplate/search/svc_www.cgi
@@ -76,7 +76,9 @@ my $addl_from = ' LEFT JOIN cust_svc  USING ( svcnum  ) '.
                 ' LEFT JOIN cust_main USING ( custnum ) ';
 
 #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 = 
   scalar(@extra_sql)
@@ -84,7 +86,7 @@ my $extra_sql =
     : '';
 
 
-my $count_query = 'SELECT COUNT(*) FROM svc_www';
+my $count_query = "SELECT COUNT(*) FROM svc_www $addl_from $extra_sql";
 my $sql_query = {
   'table'     => 'svc_www',
   'hashref'   => {},
@@ -94,7 +96,8 @@ my $sql_query = {
                    'cust_main.custnum',
                    FS::UI::Web::cust_sql_fields(),
                  ),
-  'extra_sql' => $orderby,
+  'extra_sql' => $extra_sql,
+  'order_by'  => $orderby,
   'addl_from' => $addl_from,
 };