workitem Query, how to display content from linked items

I have a new workitem link type. I can build a query to list the affected workitems on either side of the link.
workitem=defect, has link=foundin, foundin.id=25
but I would like to display the foundin.id as part of the result.
so that the user can see the collection of related workitems..(by sorting the foundin.id column)..
I don't see a mechanism to do that in a query output..
workitem=defect, has link=foundin, foundin.id=25
but I would like to display the foundin.id as part of the result.
so that the user can see the collection of related workitems..(by sorting the foundin.id column)..
I don't see a mechanism to do that in a query output..
11 answers

Hi Sam,
I don't think that is possible today. In Eclipse you can unfold the relationship and see the data, but I am not sure that s possible in the Web UI. I failed to be able to configure this.
I know this article: https://jazz.net/library/article/127
However, the query mechanism so far has limitations, especially with relationships. For instance also if trying to create conditions "like show work items where all blocking work items are closed" are, I believe, not possible today. I remember I have an open work item for this and other cases.
I don't think that is possible today. In Eclipse you can unfold the relationship and see the data, but I am not sure that s possible in the Web UI. I failed to be able to configure this.
I know this article: https://jazz.net/library/article/127
However, the query mechanism so far has limitations, especially with relationships. For instance also if trying to create conditions "like show work items where all blocking work items are closed" are, I believe, not possible today. I remember I have an open work item for this and other cases.

thanks..
show all defect workitems, where the linked workitem status = closed worked fine .. but I can't display the id of the linked workitem..
thanks for the feedback...
I think you should get the ID displayed if you select the relationship (e.g. relationship blocks) as output. What you can't do is display other attributes.

thanks..
show all defect workitems, where the linked workitem status = closed worked fine .. but I can't display the id of the linked workitem..
thanks for the feedback...
I think you should get the ID displayed if you select the relationship (e.g. relationship blocks) as output. What you can't do is display other attributes.
I don't see the relationship (link type) in the 'columns' selectable on the Result layout tab of the query.. It shows on the conditions, but not on the results.
page 1of 1 pagesof 2 pages