Dependencies and SQL queries

Hello,

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.

thanks,

Francis Peixoto
Montréal, QC
Tel : (514) 525-4298
http://www.linkedin.com/in/fpeixoto

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