On Tue, Apr 17, 2012 at 03:34:32PM -0400, Francis Peixoto wrote: > I'm using RT as a project management work tracking tool and I'm > leveraging a DBI query plugin in twiki to generate a dashboard of > ongoing projects. > > I create a main ticket as my master project timeline and I generate > child tickets for each deliverable in my WBS. > > I have been trying to find a way to generate a query where I can > properly display a parent "project" and list all child "tasks" with > their appropriate properties, but I can't seem to find the proper way. > > mind you, I don't have direct DB access, so I'm closed in to the DBI > query plugin. > > if there's some specific value I can call that represents that > relationship, then I can go from there, but I can't find any > information in the documentation.
I'm not sure I understand how you're using a DBI plugin (which presumably provides direct DB access using the DBI perl module) but don't have direct DB access. The information you're looking for is in the Links table, which you should be able to write SQL to find. -kevin
pgpri6R8djFR4.pgp
Description: PGP signature
