If I have a work item type hierarchy such as:

<parent>
- <child>
-- <grand_child>

Is there a way for to get the list of grandchildren of the parent and specify which custom fields to show? Although iteration plans provide a hierarchical view of work item, they do not allow us to specify the custom fields we'd like to show (in 1.0.1.1).

Ideally what we are looking for is a "join" query result, where we could show a query result like this:

<parent_field> <grand_child_field> .... <grand_child_field>
...
<parent_field> <grand_child_field> .... <grand_child_field>

We'd also like to be able to sort on custom fields in the result which we can not do today.

Any suggestions for this or part of this in the current release or 2.0?