It's all about the answers!

Ask a question

workitem Query, how to display content from linked items


sam detweiler (12.5k6195201) | 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
sam detweiler (12.5k6195201) | answered Mar 26 '12, 12:21 p.m.
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.


sorry, missed u said 'Web', and do see it in the Query Results output panel very right upper corner.. dropdown.. never saw this before..
man there are TOO many menus!!..

Thanks..

Sam

permanent link
Ralph Schoon (63.1k33645) | 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.

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

permanent link
Ralph Schoon (63.1k33645) | 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.5k6195201) | 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 (63.1k33645) | 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
Ralph Schoon (63.1k33645) | 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
sam detweiler (12.5k6195201) | 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 (63.1k33645) | 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.5k6195201) | 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...

Your answer


Register or to post your answer.