Have a look into the bps svn, there is a unfinished project management add on, its doing the things you are looking for.
Torsten-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: rt-Users Users rt-users@lists.bestpractical.com
Sent: Sun Mar 25 14:19:29 2007
Subject: [rt-users] Yet another Summer of Code idea (if it’s not too late)
Hierarchical ticket views.
Let’s say I have a Project, with a number of Tasks under it. It would
be nice to be able to group the Tasks under the Project, potentially
with the ability to hide/reveal the child tasks. Trying to do this in
raw SQL would be truly hideous, though I’m sure there is some bright
girl (all the best SQL coders I know are female) out there who could
figure out a way to do it.
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com