[rt-users] 25 highest priority tickets I _created_?

[Eric Eisenhart]

On Fri, 2002-11-08 at 05:13, Ruben Schattevoy wrote:
> To my understanding the requestor and the creator
> of a ticket not neccessariy need to be identically.
> 
> Would it be possible to include also a table
> "tickets I _created_" in the main windows?

I'd suggest that if you've created a ticket and you're no longer the
owner or a requestor, you should be a CC or an AdminCC.  I mean, don't
you ever create a ticket that at some point is so totally handed off to
somebody else that you don't care what goes on with it anymore? 
Wouldn't you want to automatically be Cc:ed on any responses sent to the
requestor for these tickets?

I think the "Creator" like you want is in the Ticket info, but the API
($RTDIR/lib/RT/Tickets.pm) doesn't look to me like it exposes any kind
of interface that could be used for searching or fetching based on that
information.

Drop the attached file in $RDTIR/local/WebRT/html/Elements/ and add "<&
/Elements/MyCCs &>" just like the MyRequests to your index.html, and you
get a list of the tickets you're CCed on.  I've been using it locally
and was probably gonna figure out how to send it off to the contrib
directory sometime soon.
-- 
Eric Eisenhart - Internet Services Specialist
Computing Services, Santa Rosa Junior College
1501 Mendocino Ave, Santa Rosa, CA 95401-4395
707.521.7952                FAX: 707.569.8421
AIM: ericeisenhart             ICQ: 156218985
eeisenhart at santarosa.edu    www.santarosa.edu
-------------- next part --------------
<& /Elements/TitleBoxStart, title => "25 highest priority tickets I am watching..." &>
<TABLE BORDER=0 cellspacing=0 cellpadding=1 WIDTH=100%>
<TR>
<TH align=right>#</TH>
<TH align=left>Subject</TH>
<TH align=left>Queue</TH>
<TH align=left>Status</TH>
<TH align=left>Owner</TH>
<TH> </TH>
</TR>
% while (my $Ticket = $MyTickets->Next) {
<TR>
<TD ALIGN=RIGHT>
<%$Ticket->Id%>
</TD>
<TD>
<A HREF="<% $RT::WebPath %>/Ticket/Display.html?id=<%$Ticket->Id%>">
<%$Ticket->Subject || '[no subject]'%>
</A>
</TD>
<TD>
<%$Ticket->QueueObj->Name%>
</TD><TD>
<%$Ticket->Status%>
</TD><TD>
<%$Ticket->OwnerObj->Name%>
</TD><TD ALIGN=RIGHT>
[<A HREF="<% $RT::WebPath %>/Ticket/Display.html?id=<%$Ticket->Id%>">Display</A>]
</TD>
</TR>
% }
</TABLE>
<& /Elements/TitleBoxEnd &>


<%INIT>
my $MyTickets;
$MyTickets = new RT::Tickets ($session{'CurrentUser'});
$MyTickets->LimitCc(VALUE => $session{'CurrentUser'}->EmailAddress);
$MyTickets->LimitAdminCc(VALUE => $session{'CurrentUser'}->EmailAddress);
#$MyTickets->LimitRequestor(VALUE => $session{'CurrentUser'}->EmailAddress, OPERATOR => '!=');
#$MyTickets->LimitOwner(VALUE => $session{'CurrentUser'}->Id, OPERATOR => '!=');
$MyTickets->LimitStatus(VALUE => "open");
$MyTickets->LimitStatus(VALUE => "new");
$MyTickets->OrderBy(FIELD => 'Priority', ORDER => 'DESC');
$MyTickets->RowsPerPage(25);

</%INIT>