<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>AW: Re: [rt-users] Question about Custom Page: $Ticket->HasUnresolvedDependencies</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi kenneth,<BR>
How does your query look like? I tried it several days with a good query?!?<BR>
<BR>
Thanks<BR>
<BR>
Torsten<BR>
<BR>
-----Original Message-----<BR>
From: Kenneth Crocker <KFCrocker@lbl.gov><BR>
To: Ham MI-ID, Torsten Brumm<BR>
CC: RT Users <rt-users@lists.bestpractical.com><BR>
Sent: Wed Jan 30 18:51:00 2008<BR>
Subject: Re: [rt-users] Question about Custom Page: $Ticket->HasUnresolvedDependencies<BR>
<BR>
Ham,<BR>
<BR>
<BR>
We already do that, but we use a query instead of a special page. On<BR>
your home page, you can modify it to run any query you want when you<BR>
sign-in. Our query runs against 1 or more queues (depends on the<BR>
relationships) and lists all non-resolved, non-deleted, non-closed<BR>
tickets and their children/dependencies and status, etc. By using a<BR>
query as the tool for this info, you may save yourself a lot of code<BR>
modification/maintenance. Hope this idea helps.<BR>
<BR>
<BR>
Kenn<BR>
LBNL<BR>
<BR>
On 1/30/2008 7:00 AM, Ham MI-ID, Torsten Brumm wrote:<BR>
> Hi RT Users,<BR>
><BR>
> I'm working on a very special problem at this moment for our Software<BR>
> Devel Department. Let me shortly explain my problem and my Idea to help<BR>
> our internal departments.<BR>
><BR>
> We have a internal structure like this:<BR>
><BR>
> Business Unit <-> System Analyst <-> Developer<BR>
><BR>
> Normally the BU opens a trouble tickets, a SA is checking this and open<BR>
> one or more "PreTasks" to one or more Developers. This flow is working<BR>
> fine so far, but now we are at a point, that our SA Team is loosing more<BR>
> and more the overview about all the Dependencies of the their tickets.<BR>
><BR>
> They came to me with an idea for a special page inside RT showing all<BR>
> this. The idea is:<BR>
><BR>
> SA TICKET<BR>
> | DEV Ticket<BR>
><BR>
> ID PRIO SUBJECT STATUS OWNER | ID<BR>
> PRIO SUBJECT STATUS OWNER<BR>
> ------------------------------------------------------+-----------------<BR>
> -----------------------------------------<BR>
> #1 20 TEST1 OPEN USER1<BR>
> | #15 20 PRE:TEST1 OPEN DEV1<BR>
> <BR>
> | #16 30 PRE:TEST1 OPEN DEV2<BR>
> <BR>
> | #17 10 PRE:TEST1 RESOLVED DEV3<BR>
> ------------------------------------------------------+-----------------<BR>
> -----------------------------------------<BR>
> #2 10 TEST2 OPEN USER2<BR>
> | #18 10 PRE:TEST2 NEW NOBODY<BR>
> ------------------------------------------------------+-----------------<BR>
> -----------------------------------------<BR>
> #3 50 TEST3 OPEN USER3<BR>
> | #19 20 PRE:TEST3 RESOLVED DEV1<BR>
> <BR>
> | #20 30 PRE:TEST3 OPEN DEV2<BR>
><BR>
> And so on.<BR>
><BR>
> Am at a point at this moment, where i have mostly all the code snipplet<BR>
> together, but i miss the conterpart to<BR>
> $Ticket->HasUnresolvedDependencies<BR>
><BR>
> Any Ideas how to get something? Or a workaround to this?<BR>
><BR>
> Or does anyone has already something like this?<BR>
><BR>
> Thanks for any kind of help and ideas.<BR>
><BR>
> torsten<BR>
> Kuhne + Nagel (AG & Co.) KG, Geschaftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Alfred Manke, Thorsten Meincke, Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn (Stellv.), Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Personlich haftende Gesellschaft: Kuhne & Nagel A.G., Sitz: Contern/Luxemburg Geschaftsfuhrender Verwaltungsrat: Klaus-Michael Kuhne<BR>
><BR>
><BR>
><BR>
> _______________________________________________<BR>
> <A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR>
><BR>
> Community help: <A HREF="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>
> Commercial support: sales@bestpractical.com<BR>
><BR>
><BR>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<BR>
> Buy a copy at <A HREF="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR>
><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>