X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Findex.html;h=342d88c773deff44020da5f34bc20750855078ab;hb=0692ff47a2eac65616bf24104a51e558506f1b8f;hp=d563fa0b25d3ce0142279ac3a463f47962628949;hpb=63973c641c4be00765fa27e55c57cc5b9aa4da19;p=freeside.git

diff --git a/httemplate/index.html b/httemplate/index.html
index d563fa0b2..342d88c77 100644
--- a/httemplate/index.html
+++ b/httemplate/index.html
@@ -17,11 +17,13 @@
 %    #"SELECT DISTINCT custnum FROM h_cust_main JOIN cust_main USING ( custnum )
 %    "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum )
 %       WHERE ( history_action = 'insert' OR history_action = 'replace_new' ) 
-%         AND history_user = ?
+%         AND ( history_usernum = ? OR history_user = ? )
 %       ORDER BY history_date desc" # LIMIT 10
 %    ) or die dbh->errstr;
 %
-%  $sth->execute( $FS::CurrentUser::CurrentUser->username ) or die $sth->errstr;
+%  my $curuser = $FS::CurrentUser::CurrentUser;
+%
+%  $sth->execute( $curuser->usernum, $curuser->username ) or die $sth->errstr;
 %
 %  my %saw = ();
 %  my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref };