[rt-users] dependencies and SQL queries

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120417/c88135e2/attachment.sig>