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?
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.
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
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