It's all about the answers!

Ask a question

How to show relationship attributes in query results


Michael Taylor (8865661) | asked May 02 '13, 10:16 a.m.

The query results page has a view menu (white triangle button) that contains a relationships function.  That function enables drill down capability of the query results (see image below).

 

Questions:

1.      How can the query be saved to always show designated relationships each time the query is run?  Currently the relationships have to be set on the results page each time the query is run.

2.      Rather than having to drill down multiple times for each query result row, is it possible to list relationship attributes as a column on each row of the query results?  For example, show a column for Parent ID and a column for Parent Summary.  When designing the query “column display”, the “Available columns” list doesn’t seem to offer the Parent or Child ID or any other relationship fields for that matter.

2 answers



permanent link
sam detweiler (12.5k6186201) | answered May 02 '13, 4:36 p.m.
1. can't do it in eclise.. its a display output thing.. you CAN do it on the Web UI. IF you pick the relationships as part of the content

2. not possible today with Eclipse or Web UI.

permanent link
Clement Liu (1.5k54249) | answered May 02 '13, 8:31 p.m.
Hi Mike,

In addition to Sam's comments, we've developed ourselves a custom BIRT report to display the full hierarchy of a given work item type. The reason why we developed this report is that we could't get the full parent-child hierarchy with RTC query. What RTC is offering now is quite primitive. 

Hope it helps.

Your answer


Register or to post your answer.