X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fprospect_main.pm;h=5d909a3ea0020ebc355708fe8b7c444e5311771d;hb=02d73ef84103d6bdaf49e6a179a0ad46f9719d25;hp=c54c569c36a51811242dcd58da55c287e61ccc0d;hpb=a8d4f4f83cb4382bc301ba7ed21b6a72aac1f1f7;p=freeside.git diff --git a/FS/FS/prospect_main.pm b/FS/FS/prospect_main.pm index c54c569c3..5d909a3ea 100644 --- a/FS/FS/prospect_main.pm +++ b/FS/FS/prospect_main.pm @@ -462,7 +462,7 @@ sub search { # here is the agent virtualization push @where, $FS::CurrentUser::CurrentUser->agentnums_sql; - my $extra_sql = scalar(@where) ? ' WHERE '. join(' AND ', @where) : ''; + my $extra_sql = scalar(@where) ? ' WHERE prospect_main.custnum IS NULL AND '. join(' AND ', @where) : ''; my $count_query = "SELECT COUNT(*) FROM prospect_main $extra_sql";