It's all about the answers!

Ask a question

How to retrieve multiple custom attributes in RRDI report

Krzysztof Kaźmierczyk (7.5k480103) | asked Sep 20 '13, 9:40 a.m.
edited Sep 20 '13, 9:41 a.m.
Hello all,
I would like to create the report displaying list of work items. As a columns I would like to see two custom attributes.
I know how to set one custom attribute:
and I know how to do that in BIRT:

But how to set up the RRDI report to display two custom attributes?

2 answers

permanent link
Kevin Ramer (4.5k9185201) | answered Sep 20 '13, 10:57 a.m.
There are "extensions" tables in the Operational Data Store (Request Area) that contain custom attributes grouped by type (integer, boolean, string, medium string, etc).  There is one example of reporting on custom attributes in the Info Center:

I don't like the filtering means of locating the actual values, but on the other hand, using a join on specific attribute names will eliminate Requests that do not contain that attribute.  For example, someone might want to have a report showing several custom attributes, but in RTC, not all the target work items have all the attributes.

Krzysztof Kaźmierczyk commented Sep 20 '13, 11:16 a.m.

Thanks Kevin@ I will look into that

Krzysztof Kaźmierczyk commented Sep 23 '13, 8:24 a.m.

Hi Kevin,
I have already reviewed this article. This explains hot to display the report showing only one custom attribute but still I don't have any idea how to display two custom attributes for given workitem/testcase.

Could you clarify what was your idea?

Kevin Ramer commented Sep 23 '13, 8:56 a.m.

Well, I would think that one would repeat the steps as described there for each different custom attribute that is desired in the report.  However, upon review simply dragging multiple ID,NAME,VALUE from say Request String Extension and adding filters to pick two different attributes results in neither being displayed :-(

So, for multiple attributes of the same type (or in the same extensions) the Join route is required.   Make little queries from the extension you want which include ID, NAME, VALUE with the filter there, then build up joins one at at time until all the attributes you'd want are part of the main query.

permanent link
Ken Tessier (84117) | answered Sep 27 '13, 10:51 a.m.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.