[rt-users] Question about Custom Page: $Ticket->HasUnresolvedDependencies

[Ham MI-ID, Torsten Brumm]

Hi kenneth,
How does your query look like? I tried it several days with a good query?!?

Thanks

Torsten

-----Original Message-----
From: Kenneth Crocker <KFCrocker at lbl.gov>
To: Ham MI-ID, Torsten Brumm
CC: RT Users <rt-users at lists.bestpractical.com>
Sent: Wed Jan 30 18:51:00 2008
Subject: Re: [rt-users] Question about Custom Page:	$Ticket->HasUnresolvedDependencies

Ham,


	We already do that, but we use a query instead of a special page. On 
your home page, you can modify it to run any query you want when you 
sign-in. Our query runs against 1 or more queues (depends on the 
relationships) and lists all non-resolved, non-deleted, non-closed 
tickets and their children/dependencies and status, etc. By using a 
query as the tool for this info, you may save yourself a lot of code 
modification/maintenance. Hope this idea helps.


Kenn
LBNL

On 1/30/2008 7:00 AM, Ham MI-ID, Torsten Brumm wrote:
> Hi RT Users,
> 
> I'm working on a very special problem at this moment for our Software
> Devel Department. Let me shortly explain my problem and my Idea to help
> our internal departments.
> 
> We have a internal structure like this: 
> 
> Business Unit <-> System Analyst <-> Developer
> 
> Normally the BU opens a trouble tickets, a SA is checking this and open
> one or more "PreTasks" to one or more Developers. This flow is working
> fine so far, but now we are at a point, that our SA Team is loosing more
> and more the overview about all the Dependencies of the their tickets.
> 
> They came to me with an idea for a special page inside RT showing all
> this. The idea is:
> 
> SA TICKET
> |	DEV Ticket
> 
> ID	PRIO		SUBJECT	STATUS	OWNER		|	ID
> PRIO		SUBJECT	STATUS	OWNER
> ------------------------------------------------------+-----------------
> -----------------------------------------
> #1	20		TEST1		OPEN		USER1
> |	#15	20		PRE:TEST1	OPEN		DEV1
> 	
> |	#16	30		PRE:TEST1	OPEN		DEV2
> 	
> |	#17	10		PRE:TEST1	RESOLVED	DEV3
> ------------------------------------------------------+-----------------
> -----------------------------------------
> #2	10		TEST2		OPEN		USER2
> |	#18	10		PRE:TEST2	NEW		NOBODY
> ------------------------------------------------------+-----------------
> -----------------------------------------
> #3	50		TEST3		OPEN		USER3
> |	#19	20		PRE:TEST3	RESOLVED	DEV1
> 	
> |	#20	30		PRE:TEST3	OPEN		DEV2
> 
> And so on.
> 
> Am at a point at this moment, where i have mostly all the code snipplet
> together, but i miss the conterpart to
> $Ticket->HasUnresolvedDependencies
> 
> Any Ideas how to get something? Or a workaround to this?
> 
> Or does anyone has already something like this?
> 
> Thanks for any kind of help and ideas.
> 
> torsten
> 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
> 
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080130/6f1ff82e/attachment.htm>