How to retrieve multiple custom attributes in RRDI report
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: http://sudhakarf.wordpress.com/2012/01/24/rrdi-and-custom-attributes-2/ and I know how to do that in BIRT: https://jazz.net/forum/questions/63522/retrieving-multiple-custom-attributes-in-birt-report. But how to set up the RRDI report to display two custom attributes? |
2 answers
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:
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.reports.doc/topics/qm_t_customatt.html 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. Comments
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,
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 :-(
|
I have submitted Update Reporting on data with custom attributes help topic to describe how to display multiple attributes of the same type (282566) to clarify this use case in the help topic.
Ken
|
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.