Hi Kenneth, Thanks for your help, but this is the way we also do it at the moment, but it takes too long to create all this xls files.
But thanks. I will play around more today. Torsten > Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: 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, Persönlich > haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg > Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne -----Ursprüngliche Nachricht----- > Von: Kenneth Crocker [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 30. Januar 2008 21:07 > An: Ham MI-ID, Torsten Brumm > Cc: rt-users@lists.bestpractical.com > Betreff: Re: AW: Re: [rt-users] Question about Custom Page: > $Ticket->HasUnresolvedDependencies > > Ham, > > > The following is the SQL from our query: > > ( Queue = 'TSG-RT' OR Queue = 'RT-Admin' ) AND ( Status > = 'open' > OR Status = 'resolved' OR Status = 'stalled' OR Status = > 'new' ) AND 'CF.{TSG-RT Work Category}' LIKE 'Upgrade' > > ' <b><a > href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#', > '<b><a > href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITL > E:Subject', > '__Status__', > '__OwnerName__', > '__QueueName__', > '__TimeEstimated__', > '__TimeWorked__', > '__DependsOn__', > '__Children__' > > The results look like the spreadsheet I have attached. > After I download query results to the spreadsheet, I do a > little adjusting to the titles, etc. > Hope this helps. > > > Kenn > LBNL > > On 1/30/2008 9:56 AM, Ham MI-ID, Torsten Brumm wrote: > > Hi kenneth, > > How does your query look like? I tried it several days with > a good query?!? > > > > Thanks > > > > Torsten > > > > -----Original Message----- > > From: Kenneth Crocker <[EMAIL PROTECTED]> > > To: Ham MI-ID, Torsten Brumm > > CC: RT Users <rt-users@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: [EMAIL PROTECTED] > > > Discover RT's > hidden secrets > > with RT Essentials from O'Reilly Media. > > > Buy a copy at http://rtbook.bestpractical.com > > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com