I wonder if someone could give me a little advice concerning an onscreen tree structure I’m trying to build.
I’m working with the following data structure.
How would I go about this?
I though that I could do it as a group table if I used joins to build the data source.
select mp.processName, ms.name as stageName, mt.name as taskName, assgn.dateAssigned, assgn.estimatedCompletionDate, assgn.actualCompletionDate, assgn.completionStatus from peer$Process mp left join mp.Stages ms left join ms.Tasks mt left join mt.assignments assgn
And this nearly works, except that the table shows blank lines where the query returns null when the join doesn’t produce a result. So I don’t think this is the way to do it.