It's all about the answers!

Ask a question

workitem Query, how to display content from linked items


sam detweiler (12.5k6189201) | asked Mar 25 '12, 12:07 p.m.
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..

11 answers



permanent link
Ralph Schoon (61.4k33643) | answered Mar 26 '12, 9:52 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.

permanent link
sam detweiler (12.5k6189201) | answered Mar 26 '12, 10:30 a.m.
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...

permanent link
Ralph Schoon (61.4k33643) | answered Mar 26 '12, 10:48 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.

permanent link
sam detweiler (12.5k6189201) | answered Mar 26 '12, 10:58 a.m.
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.

permanent link
Ralph Schoon (61.4k33643) | answered Mar 26 '12, 11:07 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Sam,

I get it for blocks and some other types. Not sure why you don't see it.

permanent link
Ralph Schoon (61.4k33643) | answered Mar 26 '12, 11:18 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
In the Web UI you should get the relationships in the columns to display.
In the Eclipse UI you need to go to to the menu (triangle top right of the view) and select the relationships to display. I'd suggest using the web UI.

permanent link
sam detweiler (12.5k6189201) | answered Mar 26 '12, 11:26 a.m.
query
http://i427.photobucket.com/albums/pp351/sdetweil/queryexmp.jpg

the condition is a linked workitem (fixed in is a linktype)

http://i427.photobucket.com/albums/pp351/sdetweil/condlist.jpg

the results don't list it

http://i427.photobucket.com/albums/pp351/sdetweil/queryresults.jpg

permanent link
Ralph Schoon (61.4k33643) | answered Mar 26 '12, 11:28 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Which UI is that? The Eclipse UI?

permanent link
sam detweiler (12.5k6189201) | answered Mar 26 '12, 11:52 a.m.
yes, Eclipse 3.0.1.1

permanent link
Ralph Schoon (61.4k33643) | answered Mar 26 '12, 11:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
As I mentioned, use the Web UI. In the Eclipse client you don't see the relationships there. You have to configure that in the View Menu in the Eclipse client. The Web UI is better for this.

Your answer


Register or to post your answer.