X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Frt_transaction.html;h=34fb733a36415128d51f9d344c5a665f29772047;hb=4f25d34901fb6a358af5b5009608c5162e745042;hp=651f2896dd47bc42bca983d9001b5f62a685201c;hpb=624b2d44625f69d71175c3348cae635d580c890b;p=freeside.git diff --git a/httemplate/search/rt_transaction.html b/httemplate/search/rt_transaction.html index 651f2896d..34fb733a3 100644 --- a/httemplate/search/rt_transaction.html +++ b/httemplate/search/rt_transaction.html @@ -77,6 +77,10 @@ if ( $cgi->param('otaker') && $cgi->param('otaker') =~ /^([\w\.\-]+)$/ ) { $where .= " AND Users.name = '$1' "; } +if ( $cgi->param('ticketid') =~ /^\s*(\d+)\s*$/ ) { + $where .= " AND Tickets.ID = $1"; +} + my $query = { 'select' => "Transactions.*, Tickets.Id AS ticketid, Tickets.Subject, Users.name as otaker, $transactiontime AS transaction_time", #'table' => 'Transactions', @@ -91,6 +95,6 @@ my $query = { my $count_query = "SELECT COUNT(*), SUM($transactiontime) FROM Transactions $join $where"; -my $link = [ "${p}rt/Ticket/Display.html?id=", sub { shift->get('id'); } ]; +my $link = [ "${p}rt/Ticket/Display.html?id=", sub { shift->get('ticketid'); } ];