<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! Report on custom attributes and enumerations <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/uc.png" alt="uc.png" width="50" height="50" align="right"> %DKGRAY% Authors: Main.LuizSouza <br> Build basis: IBM Rational Reporting for Development Intelligence (RRDI), IBM Rational Team Concert (RTC) %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph Introductory paragraph ---++ Background Before proceeding with the instructions below, review the following explanation of how custom attributes are set up: In RRDI, when you open Report Studio, there are 2 main areas you have to look for: 1. *Requests* </br> This holds the work items you want to use in your report </br></br> 1. *Request String Extension* </br></br> This holds the custom attributes. The column *VALUE* contains the custom attribute value, or in the case of the custom attribute being an *ENUMERATION*, then the column *VALUE* contains the key of the table of enumeration, represented in Report Studio by *Request Enumeration*. So basically, what you have to do is create a couple of query joins in Report Studio to access your Custom Attributes. *IMPORTANT*: You will find the package you are going to use in Report Studio under *> Operational Data Store > Request Area > Request String Extension*. </br><img alt="report-studio-package.jpg" src="%ATTACHURL%/report-studio-package.jpg" /> ---++Step by Step process to report on Custom Attributes with Enumeration: 1. In the RTC interface where you define custom attributes, check the ID of the custom attribute you want. You are going to use this value later in the process. </br> </br> 1. While in this interface, check the type of this custom attribute. This type will tell you what table it is stored in RRDI. There are several kinds of tables with names such as *REQUEST_INT_EXT*, *REQUEST_STRING_EXT*, and others. These tables are represented in the package in Report Studio with names such as *Request String Extension*, and others. </br> </br> 1. In Report Studio, create three queries, one for *Request* (named Work_Item for this example), *Request String Extension* and another for *Request Enumeration*. </br> </br><img alt="three-queries.jpg" src="%ATTACHURL%/three-queries.jpg" /></br></br> *Very Important:* Using the value of the ID of the custom attribute from step #1, create a filter in the *Request String Extension* query associated with the *Name* column. </br> </br> In the example below [Name] = 'com.ibm.team.apt.attribute.complexity' </br> </br> </br><img alt="request-string-extension.jpg" src="%ATTACHURL%/request-string-extension.jpg" /></br> </br> 1. Create a join with Work_Item and Request String Extension </br> </br> </br><img alt="create-a-join.jpg" src="%ATTACHURL%/create-a-join.jpg" /></br> </br> </br><img alt="join-relationships.jpg" src="%ATTACHURL%/join-relationships.jpg" /></br> </br> Double click the Relationship node <img alt="join.jpg" src="%ATTACHURL%/join.jpg" /> and set the relationship as illustrated above. Under *Work_Item* select the *Request ID* column name and again under *Request String Extension* you should also select the *Request ID* column name. Then click *OK* and the join relationship will be created. </br> </br> Do not forget to populate the query <img alt="populate-query.jpg" src="%ATTACHURL%/populate-query.jpg" /> with the columns from the two queries of the join. </br></br> 1. Now, create another join with the query above and the *Request Enumeration* query: </br> </br> </br><img alt="create-another-join.jpg" src="%ATTACHURL%/create-another-join.jpg" /></br> For this join, create the following relationship:</br> </br><img alt="create-relationship.jpg" src="%ATTACHURL%/create-relationship.jpg" /></br> </br> Under *Request_Req_String_Ext* select the *Value* column name and under *Request Enumeration* select the *External ID* column name, then click *OK* and the join relationship will be created. These columns define the relationship of this join.</br> </br> 1. Create your report </br></br> Now, in Report Studio you might see something like this: </br> </br><img alt="report-studio.jpg" src="%ATTACHURL%/report-studio.jpg" /></br></br> What you have to do now is to use the *REQ_ENUMERATION* query above in your reports. Below is an example: </br> </br><img alt="example-table.jpg" src="%ATTACHURL%/example-table.jpg" /></br> </br> 1. The column *Literal Name* has the value of your custom attribute enumeration. </br> *Important:* Make sure the person running the report has the appropriate access rights for the Project Area from which you want to extract work items. ---+++++!! Related topics: [[WebHome][Deployment web home]] ---+++++!! External links: * [[https://www.ibm.com][IBM]] ---+++++!! Additional contributors: Main.TWikiUser ---+++++!! Questions and comments: %COMMENT{type="below" target="ReportingOnCustomAttributesAndEnumerationsComments" button="Submit"}% %INCLUDE{"ReportingOnCustomAttributesAndEnumerationsComments"}% <sticky></div></sticky>
This topic: Deployment
>
WebHome
>
DeploymentIntegrating
>
DeploymentIntegratingReporting
>
ReportingOnCustomAttributesAndEnumerations
History: r7 - 2014-12-23 - 14:32:59 - Main.dmmckinn
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
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
.