Admin: 2 revisions imported

2016-04-06T20:39:41Z

2 revisions imported

New page

Based on [[QueueSummary]], aka the "Quick search" box on the RT at a glance page, this gives you a grid showing how many tickets the user is listed as Requestor, Cc, Owner, or [[AdminCc]] of, and what the status of the ticket is, with links to the searches showing the actual tickets.

It looks something like this:

=== Watched Tickets ===

{| border="1"
|- valign="top"
| Type
| new
| open
| stalled
| resolved
| rejected
|- valign="top"
| Requestor
| 45
| 2
| ‎0
| 579
| ‎0
|- valign="top"
| Owner
| ‎0
| ‎0
| ‎0
| 49
| ‎0
|- valign="top"
| Cc
| ‎0
| ‎0
| ‎0
| ‎0
| ‎0
|}

| [[AdminCc]] | ‎0 | ‎0 | ‎0 | 1 | ‎0 |

Put this into html/Elements/[[WatcherSummary]]:

<table border="0" cellspacing="0" cellpadding="1" width="100%">
<tr>
<th class="collection-as-table"><&|/l&>Type</&></th>
% for my $condition (@$conditions) {
<th class="collection-as-table"><% $condition->{name} %></th>
% }
</tr>
% my $i;
% for my $type (@types) {
% $i++;
% my $type_cond = "$type.Id = ".$UserObj->Id;
% my $all_q = $type_cond;
<tr class="<% $i%2 ? 'oddline' : 'evenline'%>" >
<td><a href="<% $RT::WebPath%>/Search/Results.html?Query=<%$all_q%>"><%$type%></a></td>
% for my $condition (@$conditions) {
% my $Tickets = RT::Tickets->new($session{'CurrentUser'});
% $Tickets->FromSQL($type_cond." AND ".$condition->{cond});
<td align="right"><a href="<% $RT::WebPath%>/Search/Results.html?Query=<%$type_cond." AND ".$condition->{cond}%>"><% $Tickets->Count %></a></td>
% }
</tr>
% }
</table>
<%INIT>
my @types = ('Requestor', 'Owner', 'Cc', 'AdminCc');
</%INIT>
<%ARGS>
$UserObj => undef
$conditions => ()
</%ARGS>

I like to use it in Admin/Users/Memberships.html, like so:

--- share/html/Admin/Users/Memberships.html 2006-06-19 15:44:04.000000000 -0700
+++ local/html/Admin/Users/Memberships.html 2006-09-20 16:37:26.000000000 -0700
@@ -54,6 +54,17 @@

<& /Elements/ShowMemberships, UserObj => $UserObj &>

+<&| /Widgets/TitleBox, title => loc('Watched Tickets'),
+ title_href => "$RT::WebPath/Search/Results.html?Query=Watcher.Id=".$UserObj->Id &>
+<& /Elements/WatcherSummary,
+ UserObj => $UserObj,
+ conditions => [ {cond => "Status = 'new'", name => loc ('new') },
+ {cond => "Status = 'open'", name => loc ('open') },
+ {cond => "Status = 'stalled'", name => loc ('stalled') },
+ {cond => "Status = 'resolved'", name => loc ('resolved') },
+ {cond => "Status = 'rejected'", name => loc ('rejected') }] &>
+</&>
+
<%INIT>
my $UserObj = RT::User->new($session{'CurrentUser'});
$UserObj->Load($id) || Abort("Couldn't load user '$id'");

WatcherSummary - Revision history

Admin: 2 revisions imported