It's all about the answers!

Ask a question

How can I make a query with an attribute of the highest parent (not the immediate parent)?


Vicky Pagnaer (63129) | asked Oct 26 '16, 4:34 a.m.
 All our work items are hierarchically linked:
* Project
    * Requirement
          * Task / Change / Defect

We often have situations where we need to find all low-level work items (like tasks) of which the highest-level work item (a project) has specific attributes. For example, we would like to find all work items belonging to a project or find all work items of which the project has a specific tag.

In the query editor, you can only link to the immediate parent. Is there any way to query for this using the available options in the query editor? Or is there any other way to make such a query?

Comments
Vicky Pagnaer commented Oct 26 '16, 4:35 a.m.

 I'd like to add that there might be multiple levels of requirements between the project and the lowest-level task, depending on the complexity.

One answer



permanent link
Miguel Tomico (5001323) | answered Oct 26 '16, 5:07 a.m.

I don't think you can query based on that by using the query editor.

Try JRS. Otherwise, BIRT. Otherwise, a Java API script.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.