1 <&|Elements/Wrapper, %ARGS, title => loc("Resolution Comments"),
2 path => "Reports/Activity/ResolutionComments.html",
5 <table style="width: 100%">
7 <th>Queue</th><th>Ticket #</th><th>Created</th><th>Resolved</th><th>Time to resolve</th>
10 <th colspan="5">Resolution comments</th>
12 % for my $item (@items) {
14 <td><% $item->{queue} %></td>
15 <td><% $item->{id} %></td>
16 <td><% $item->{created} %></td>
17 <td><% $item->{resolved} %></td>
18 <td><% $item->{duration} %></td>
21 <td colspan="5"><% $item->{whiteboard} %></td>
29 $start => "2005/01/01"
36 my $summary_tickets = RT::Tickets->new( $session{'CurrentUser'} );
37 $summary_tickets->FromSQL(
38 $query . " AND (Status = 'resolved') AND ( Updated >= '$start' AND Updated <= '$end')" );
41 while ( my $ticket = $summary_tickets->Next ) {
43 queue => $ticket->QueueObj->Name,
45 created => $ticket->CreatedObj->AsString,
46 resolved => $ticket->ResolvedObj->AsString,
47 duration => Time::Duration::concise(
48 Time::Duration::duration(
49 $ticket->ResolvedObj->Unix - $ticket->CreatedObj->Unix
52 whiteboard => $ticket->FirstCustomFieldValue('Whiteboard')
56 @items = sort { $a->{queue} cmp $b->{queue} || $a->{id} <=> $b->{id} } @items;