finding work items with incorrect planned for values
I want to find all work items that are children of work items planned for iteration X but are not themselves planned for iteration X. I tried writing a query where the Planned For is not part of X and Parent > Planned For is part of X but it doesn't return the correct results (I get some work items where parent and child are both planned for iteration X).
Is there a better way to find these work items?
Is there a better way to find these work items?
Accepted answer
Hi Eric,
I am pretty sure this is almost impossible to do with a query. There are limitations on what a query can do today, especially with respect to relationships and conditions such as exists and for all.
You can try to create a query that returns all items planned for the iteration in the eclipse client and then show the parent relationship. You can unfold the parents and see the planned for of both.
I think it might be easier to create a plan for the iteration. In the work breakdown view you should see all the parents and they would indicate if they are planned for a different iteration.
I am pretty sure this is almost impossible to do with a query. There are limitations on what a query can do today, especially with respect to relationships and conditions such as exists and for all.
You can try to create a query that returns all items planned for the iteration in the eclipse client and then show the parent relationship. You can unfold the parents and see the planned for of both.
I think it might be easier to create a plan for the iteration. In the work breakdown view you should see all the parents and they would indicate if they are planned for a different iteration.
