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

[Kenneth Crocker]

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>/TITLE: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 <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 --------------
A non-text attachment was scrubbed...
Name: RT Demo Report1.xls
Type: application/vnd.ms-excel
Size: 16384 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080130/8c20d7e1/attachment.xls>