How to retrieve multiple custom attributes in RRDI report
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
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
Thanks Kevin@ I will look into that
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?
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.